GP_PAYEE_SELIND(SQL Table) |
Index Back |
---|---|
Payee selection indicatorPayee selection indicator(payroll/Absence) record |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | GP_PAYEE_SELECT_ID | Character(12) | VARCHAR2(12) NOT NULL | Payee selection ID |
2 | EMPL_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Payroll Status
A=Active D=Deceased L=Leave of Absence P=Leave With Pay Q=Retired With Pay R=Retired S=Suspended T=Terminated U=Terminated With Pay V=Terminated Pension Pay Out W=Short Work Break X=Retired-Pension Administration |
3 | GP_ABS_IND | Character(1) | VARCHAR2(1) NOT NULL |
GP Absence Indicator
N=No Y=Yes Default Value: Y |
4 | GP_PAYROLL_IND | Character(1) | VARCHAR2(1) NOT NULL |
Payroll Indicator
N=No Y=Yes Default Value: Y |