GP_PAYGROUPPrompt Table: GP_PYGRP
CAL_IDPrompt Table: GP_CAL_PRD
GP_CAL_DATE_VW(SQL View) |
Index Back |
|---|---|
Calendar Date ViewCalendar Date View |
| SELECT A.GP_PAYGROUP , A.CAL_ID , A.CAL_PRD_ID , B.PRD_BGN_DT , B.PRD_END_DT FROM PS_GP_CALENDAR A , PS_GP_CAL_PRD B WHERE A.CAL_PRD_ID = B.CAL_PRD_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GP_PAYGROUP |
Character(10) | VARCHAR2(10) NOT NULL |
Global Payroll pay group
Prompt Table: GP_PYGRP |
| 2 | CAL_ID |
Character(18) | VARCHAR2(18) NOT NULL | calendar id |
| 3 | CAL_PRD_ID | Character(10) | VARCHAR2(10) NOT NULL |
Calendar Period ID
Prompt Table: GP_CAL_PRD |
| 4 | PRD_BGN_DT | Date(10) | DATE | Period Begin Date |
| 5 | PRD_END_DT | Date(10) | DATE | Pay Period End Date |