GDP_CONTEXT_STP(SQL Table) |
Index Back |
---|---|
GDP Setup Context RecordGuided Process Setup Context Record |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | REG_REGION | Character(5) | VARCHAR2(5) NOT NULL | Regulatory Region |
2 | SEQUENCENO | Number(10,0) | DECIMAL(10) NOT NULL | Sequence Number |
3 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
4 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
5 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
6 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
7 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Location Code |
8 | JOBCODE | Character(6) | VARCHAR2(6) NOT NULL | Job Code |
9 | POSITION_NBR | Character(8) | VARCHAR2(8) NOT NULL | Position Number |
10 | PAYGROUP | Character(3) | VARCHAR2(3) NOT NULL | Pay Group |
11 | SAL_ADMIN_PLAN | Character(4) | VARCHAR2(4) NOT NULL | Salary Administration Plan |
12 | GRADE | Character(3) | VARCHAR2(3) NOT NULL | Salary Grade |
13 | STEP | Number(2,0) | SMALLINT NOT NULL | Step |
14 | WCS_ROUND_ID | Character(6) | VARCHAR2(6) NOT NULL | Rounding Rule ID |
15 | WCS_PRORATE_ID | Character(6) | VARCHAR2(6) NOT NULL | Proration Rule Identifier |
16 | BUDGET_ID | Character(10) | VARCHAR2(10) NOT NULL | Budget ID |
17 | VC_PLAN_ID | Character(10) | VARCHAR2(10) NOT NULL | VC Plan ID |
18 | PLAN_TYPE | Character(2) | VARCHAR2(2) NOT NULL | Identifies a category of benefit plan, such as Medical, Dental, and Life (Insurance). A set of plan type codes, as well as rules for creating new codes, is provided by PeopleSoft. Plan Type codes determine how the system processes and defines eligibility for the various benefit plans. |
19 | BENEFIT_PLAN | Character(6) | VARCHAR2(6) NOT NULL | Benefit Plan |