SRC_CAL_RUN_IDGP_PAYGROUPCAL_SEQ_NUMGP_OFFLOAD_A_VW(SQL View) |
Index Back |
|---|---|
Load Off Cycle AdvancesThis is a copy of the GP_OFFCYCL_A_VW used to load calendars for advance into the off cycle buffer |
| SELECT CRD.CAL_RUN_ID , CRD.GP_PAYGROUP , CRD.CAL_SEQ_NUM , CRD.CAL_ID , CAL.PYMT_DT , CAL.RUN_TYPE , PRD.PRD_BGN_DT , PRD.PRD_END_DT FROM PS_GP_CAL_RUN_DTL CRD , PS_GP_CAL_PRD PRD , PS_GP_CALENDAR CAL WHERE CRD.CAL_ID=CAL.CAL_ID AND CRD.GP_PAYGROUP=CAL.GP_PAYGROUP AND CAL.CAL_PRD_ID=PRD.CAL_PRD_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SRC_CAL_RUN_ID |
Character(18) | VARCHAR2(18) NOT NULL | Source Calendar Run ID |
| 2 | GP_PAYGROUP |
Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group |
| 3 | CAL_SEQ_NUM |
Number(8,0) | INTEGER NOT NULL | Calendar Sequence Number |
| 4 | CAL_ID | Character(18) | VARCHAR2(18) NOT NULL | calendar id |
| 5 | PYMT_DT | Date(10) | DATE | Payment Date |
| 6 | RUN_TYPE | Character(10) | VARCHAR2(10) NOT NULL | Run Type Name |
| 7 | PRD_BGN_DT | Date(10) | DATE | Period Begin Date |
| 8 | PRD_END_DT | Date(10) | DATE | Pay Period End Date |