OI_GEN_DATE(SQL Table) |
Index Back |
|---|---|
OTBI: Generate Dates/CalendarsOTBI: Generate Dates/Calendars |
| # | 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 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SETID_TBL |
| 4 | CALENDAR_ID | Character(2) | VARCHAR2(2) NOT NULL | Calendar ID |
| 5 | DETAIL_CALENDAR | Character(2) | VARCHAR2(2) NOT NULL |
Detail Calendar
Prompt Table: OI_CAL_ID_VW |
| 6 | FISCAL_YEAR_FROM | Number(4,0) | SMALLINT NOT NULL |
Fiscal Year
Prompt Table: %EDITTABLE |
| 7 | FISCAL_YEAR_TO | Number(4,0) | SMALLINT NOT NULL |
Range To Fiscal Year
Prompt Table: %EDITTABLE |
| 8 | BALANCE_FWD_SW | Character(1) | VARCHAR2(1) NOT NULL |
A flag that indicates (Y or N) whether or not the YTD balance for an account type or for a statistical account will be rolled forward to Period 0 of the next year.
N=Not Carry Forward O=Other Y=Carry Forward |
| 9 | ADJUSTMENT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Adjustment Type
D=Discount S=Surcharge |
| 10 | OI_BUDGET_PERIOD | Character(1) | VARCHAR2(1) NOT NULL |
Budget Period
N=Ignore Budget Period Data Y=Load Budget Period Data |
| 11 | OI_BUDGET_CALENDAR | Character(20) | VARCHAR2(20) NOT NULL |
Budget Calendar Id
Prompt Table: OI_BUD_PER_VW |
| 12 | OI_FRM_BUD_PEROID | Character(25) | VARCHAR2(25) NOT NULL |
From Budget Period
Prompt Table: OI_BUD_PER_VW1 |
| 13 | OI_TO_BUD_PEROID | Character(25) | VARCHAR2(25) NOT NULL |
From Budget Period
Prompt Table: OI_BUD_PER_VW1 |