CAL_RUN_IDGPAU_STPCLRN_VW(SQL View) |
Index Back |
|---|---|
Calendar Run DetailsCalendar Run Definition Details |
| SELECT DISTINCT P.PAY_ENTITY ,P.GP_PAYGROUP ,O.CAL_RUN_ID ,O.CAL_PRD_ID ,C.PRD_BGN_DT ,C.PRD_END_DT ,O.PYMT_DT ,O.PYMT_DT ,R.OFF_CYCLE ,R.RUN_OPEN_TS ,R.RUN_FINALIZED_TS FROM PS_GP_CAL_RUN R , PS_GP_PYGRP P , PS_GP_OFFCYCLE O , PS_GP_CAL_PRD C WHERE R.CAL_RUN_ID=O.CAL_RUN_ID AND P.GP_PAYGROUP=O.GP_PAYGROUP AND O.CAL_PRD_ID=C.CAL_PRD_ID UNION SELECT DISTINCT P.PAY_ENTITY ,P.GP_PAYGROUP ,G.CAL_RUN_ID ,O.CAL_PRD_ID ,C.PRD_BGN_DT ,C.PRD_END_DT ,O.PYMT_DT ,O.PYMT_DT ,R.OFF_CYCLE ,R.RUN_OPEN_TS ,R.RUN_FINALIZED_TS FROM PS_GP_CAL_RUN R , PS_GP_PYGRP P , PS_GP_CALENDAR O ,PS_GP_CAL_RUN_DTL G , PS_GP_CAL_PRD C WHERE R.CAL_RUN_ID=G.CAL_RUN_ID AND P.PAY_ENTITY=G.PAY_ENTITY AND P.GP_PAYGROUP=G.GP_PAYGROUP AND P.GP_PAYGROUP=O.GP_PAYGROUP AND O.CAL_ID= G.CAL_ID AND O.CAL_PRD_ID=C.CAL_PRD_ID AND G.CALC_TYPE='P' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PAY_ENTITY | Character(10) | VARCHAR2(10) NOT NULL | Pay Entity |
| 2 | GP_PAYGROUP | Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group |
| 3 | CAL_RUN_ID |
Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id |
| 4 | CAL_PRD_ID | Character(10) | VARCHAR2(10) NOT NULL | Calendar Period ID |
| 5 | PRD_BGN_DT | Date(10) | DATE | Period Begin Date |
| 6 | PRD_END_DT | Date(10) | DATE | Pay Period End Date |
| 7 | PYMT_DT | Date(10) | DATE | Payment Date |
| 8 | GPAU_PYMT_DT | Date(10) | DATE | Payment Date |
| 9 | OFF_CYCLE | Character(1) | VARCHAR2(1) NOT NULL | Off Cycle ? |
| 10 | CAL_IDNT_TS | DateTime(26) | TIMESTAMP | Calendar Identify Timestamp |
| 11 | CAL_FINAL_TS | DateTime(26) | TIMESTAMP | Calendar Finalized Timestamp |