GP_PAYGROUPCAL_IDY/N Table Edit
A=Absence Calculation
B=All Calculations
P=Payroll Calculation
GP_CAL_DTL3_VW(SQL View) |
Index Back |
|---|---|
View CalendarsCalendar View used for selection in Off-Cycle |
| SELECT DTL.GP_PAYGROUP , DTL.CAL_ID , CR.RUN_FINALIZED_IND , DTL.CAL_RUN_ID , DTL.CAL_SEQ_NUM , DTL.PRD_BGN_DT , DTL.PRD_END_DT , RT.CALC_TYPE FROM PS_GP_CAL_RUN_DTL DTL , PS_GP_RUN_TYPE RT , PS_GP_CAL_RUN CR WHERE DTL.RUN_TYPE=RT.RUN_TYPE AND DTL.CAL_RUN_ID=CR.CAL_RUN_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GP_PAYGROUP |
Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group |
| 2 | CAL_ID |
Character(18) | VARCHAR2(18) NOT NULL | calendar id |
| 3 | RUN_FINALIZED_IND | Character(1) | VARCHAR2(1) NOT NULL |
Finalized Run
Y/N Table Edit |
| 4 | CAL_RUN_ID | Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id |
| 5 | CAL_SEQ_NUM | Number(8,0) | INTEGER NOT NULL | Calendar Sequence Number |
| 6 | PRD_BGN_DT | Date(10) | DATE | Period Begin Date |
| 7 | PRD_END_DT | Date(10) | DATE | Pay Period End Date |
| 8 | 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 |