GP_CALENDAR_PYE(SQL Table) |
Index Back |
---|---|
Calendar PayeeCalendar Payee |
# | 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 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERS_SRCH_GBL |
4 | CALC_THRU_DT | Date(10) | DATE |
Calculate Thru Date
Default Value: GP_CALENDAR.CALC_THRU_DT |