GPSG_CAL_PRD(SQL View) |
Index Back |
|---|---|
Calendar group and pay periodCalendar group and pay period |
| SELECT DISTINCT TC.cal_run_id ,TC.gp_paygroup , TC.cal_prd_id FROM PS_GP_CAL_RUN_OFF TC UNION SELECT DISTINCT TA.cal_run_id , ta.gp_paygroup , ta.cal_prd_id FROM PS_GP_CAL_RUN_DTL TA WHERE ta.calc_type = 'P' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CAL_RUN_ID | Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id |
| 2 | GP_PAYGROUP | Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group |
| 3 | CAL_PRD_ID | Character(10) | VARCHAR2(10) NOT NULL | Calendar Period ID |