CAL_RUN_IDGP_PAYGROUPCAL_IDGP_ABS_CALRN_VW(SQL View) |
Index Back |
|---|---|
Absence Mngmt CalRunDtl viewCalRunDtl view used for Absence Management Create Interface File to show what Calendars are included in a given Calendar Group. Only include those that are not Calc Type of Payroll which is for Global Payroll. |
| SELECT CAL_RUN_ID , GP_PAYGROUP , CAL_ID FROM PS_GP_CAL_RUN_DTL WHERE CALC_TYPE = 'A' |
| # | 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_ID |
Character(18) | VARCHAR2(18) NOT NULL | calendar id |