CAL_RUN_IDF=Finalized
N=Not Processed
P=Processed
HGA_CAL_FNL_VW(SQL View) |
Index Back |
|---|---|
Abs Finalized calendarsAbsence Finalized calendars view used for Pivot grids. |
| SELECT CAL_RUN_ID , DESCR , 'F' , RUN_FINALIZED_IND FROM PS_GP_CAL_RUN WHERE RUN_FINALIZED_IND = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CAL_RUN_ID |
Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | GP_ABS_EVT_STAT | Character(1) | VARCHAR2(1) NOT NULL |
Absence event status
F=Finalized N=Not Processed P=Processed |
| 4 | RUN_FINALIZED_IND | Character(1) | VARCHAR2(1) NOT NULL | Finalized Run |