OPRIDRUN_CNTL_IDLEVEL1SUMM_CALENDAR_IDPrompt Table: OI_SMCAL_ID_VW
MNTH=Month
QUTR=Quarter
SANN=Semi-Annual
WEEK=Week
YEAR=Year
Default Value: YEAR
OI_GENDT_GRD(SQL Table) |
Index Back |
|---|---|
Period Flattener Grid recordPeriod Flattener Grid record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | LEVEL1 |
Number(5,0) | INTEGER NOT NULL | Level |
| 4 | SUMM_CALENDAR_ID |
Character(2) | VARCHAR2(2) NOT NULL |
SUMM_CALENDAR_ID
Prompt Table: OI_SMCAL_ID_VW |
| 5 | HIERARCHY_LABEL | Character(4) | VARCHAR2(4) NOT NULL |
HIERARCHY_LABEL
MNTH=Month QUTR=Quarter SANN=Semi-Annual WEEK=Week YEAR=Year Default Value: YEAR |