SETIDDefault Value: OPR_DEF_TBL_HR.SETID
Prompt Table: SETID_TBL
DEPTIDBGN_DT0=No Target Region
1=Target Region 1
2=Target Region 2
3=Transition Region
GPDE_KU_DEPT(SQL Table) |
Index Back |
|---|---|
Departments KUG DefinitionDepartments KUG Definition to assign KUG periods and identifiers to a department |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_HR.SETID Prompt Table: SETID_TBL |
| 2 | DEPTID |
Character(10) | VARCHAR2(10) NOT NULL | Department |
| 3 | BGN_DT |
Date(10) | DATE | Begin Date |
| 4 | END_DT | Date(10) | DATE | end date |
| 5 | GPDE_KU_ID_NUM | Character(18) | VARCHAR2(18) NOT NULL | KUG Idententification Number assigned by the BA for the KUG period |
| 6 | GPDE_KU_TARGET_REG | Character(1) | VARCHAR2(1) NOT NULL |
KUG Refund SI contribution
0=No Target Region 1=Target Region 1 2=Target Region 2 3=Transition Region |