CAL_RUN_IDF=Finalized
N=Not Processed
P=Processed
HGA_CAL_STAT_VW(SQL View) |
Index Back |
|---|---|
Absence Process StatusAbsence Process Status Details used for Pivot grids |
| SELECT CAL.CAL_RUN_ID , CAL.DESCR , %Coalesce(CAL1.GP_ABS_EVT_STAT, 'P') , CAL.RUN_FINALIZED_IND , CAL.RUN_FINALIZED_TS FROM PS_GP_CAL_RUN CAL LEFT OUTER JOIN PS_HGA_CAL_FNL_VW CAL1 ON CAL1.CAL_RUN_ID = CAL.CAL_RUN_ID AND CAL1.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 |
| 5 | RUN_FINALIZED_TS | DateTime(26) | TIMESTAMP | Finalized Timestamp |