CAL_RUN_IDCOUNTRYGP_PAYGROUPA=Absence Calculation
B=All Calculations
P=Payroll Calculation
GP_CAL_RUNOF_VW(SQL View) |
Index Back |
|---|---|
Calendar calc typeCalendar calc type |
| SELECT DISTINCT CAL_RUN_ID ,COUNTRY ,GP_PAYGROUP ,CAL_ID ,PRD_END_DT ,PRD_BGN_DT ,CALC_TYPE FROM PS_GP_CAL_RUN_DTL WHERE CAL_IDNT_TS IS NOT NULL UNION SELECT DISTINCT B.CAL_RUN_ID ,( SELECT DISTINCT A.COUNTRY FROM PS_GP_CAL_RUN A WHERE A.CAL_RUN_ID = B.CAL_RUN_ID) ,B.GP_PAYGROUP ,' ' ,( SELECT D.PRD_END_DT FROM PS_GP_CAL_PRD D WHERE D.CAL_PRD_ID = B.CAL_PRD_ID), ( SELECT C.PRD_BGN_DT FROM PS_GP_CAL_PRD C WHERE C.CAL_PRD_ID = B.CAL_PRD_ID),'P' FROM PS_GP_CAL_RUN_OFF B WHERE B.CAL_RUN_ID <> ' ' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CAL_RUN_ID |
Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id |
| 2 | COUNTRY |
Character(3) | VARCHAR2(3) NOT NULL | Country |
| 3 | GP_PAYGROUP |
Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group |
| 4 | CAL_ID | Character(18) | VARCHAR2(18) NOT NULL | calendar id |
| 5 | PRD_END_DT | Date(10) | DATE | Pay Period End Date |
| 6 | PRD_BGN_DT | Date(10) | DATE | Period Begin Date |
| 7 | CALC_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Calculation Process Type. Identifies a run as either absence run or payroll run
A=Absence Calculation B=All Calculations P=Payroll Calculation |