GDP_CONTEXT_STP

(SQL Table)
Index Back

GDP Setup Context Record

Guided 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