UPG_HR_AET (SQL Table)	Index Back
Upgrade State Record HR 8 SP 1

UPG_HR_AET

(SQL Table)

Upgrade State Record

HR 8 SP 1

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1

3 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2

4 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3

5 ADDRESS_TYPE Character(4) VARCHAR2(4) NOT NULL Address Type

6 ADDRESS_TYPE_OTH Character(4) VARCHAR2(4) NOT NULL Address Type

7 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1

8 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2

9 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3

10 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4

11 CITY Character(30) VARCHAR2(30) NOT NULL City

12 CITIZENSHIP_STATUS Character(1) VARCHAR2(1) NOT NULL Citizenship Status

13 COUNTY Character(30) VARCHAR2(30) NOT NULL County

14 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

15 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2

16 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1

17 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
AB=House Boat Reference
WW=House Trailer Reference

18 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code

19 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

20 STATE Character(6) VARCHAR2(6) NOT NULL State

21 DATETIME_STAMP DateTime(26) TIMESTAMP DateTime Stamp

22 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

23 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

24 EFFDT Date(10) DATE Effective Date

25 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence

26 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

27 DUR Date(10) DATE Date Under Report associates time being reported, scheduled or paid, to a specific date.

28 EXCEPTION_ID Character(8) VARCHAR2(8) NOT NULL Exception ID

29 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number

30 SETID Character(5) VARCHAR2(5) NOT NULL SetID

31 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

32 DESCR Character(30) VARCHAR2(30) NOT NULL Description

33 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description

34 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

35 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254

36 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region

37 ERNCD Character(3) VARCHAR2(3) NOT NULL Earnings Code

38 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.

39 BENEFIT_PLAN Character(6) VARCHAR2(6) NOT NULL Benefit Plan

40 PRIOR_EMPLID Character(11) VARCHAR2(11) NOT NULL Prior Emplid

41 PRIOR_EMPL_RCD Number(3,0) SMALLINT NOT NULL Prior Employee Record Number

42 PRIOR_EFFDT Date(10) DATE Prior Effective Date

43 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

44 LANG_CD Character(3) VARCHAR2(3) NOT NULL Language Code
CFR=Canadian French
DAN=Danish
DUT=Dutch
ENG=English
ESP=Spanish
FRA=French
GER=German
GRK=Greek
INE=International English
ITA=Italian
JPN=Japanese
KOR=Korean
POR=Portuguese
SVE=Swedish
THA=Thai
ZHS=Simplified Chinese
ZHT=Traditional Chinese

45 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal

46 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number

47 CONTRACT_NBR_BEL Number(3,0) SMALLINT NOT NULL Contract Seq. Number

48 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract Number

49 NULL_WORK_DATE Date(10) DATE This field is used for the HRMS 8 Upgrade.

50 HIRE_DT Date(10) DATE First Start Date

51 COMMENTS Long Character CLOB Comment

52 EVENTNAME Character(30) VARCHAR2(30) NOT NULL Defines a routing event for PS Workflow

53 INSTANCEID Number(10,0) DECIMAL(10) NOT NULL For a given worklist the unique number of rows in PSWORKLIST

54 TRANSACTIONID Number(10,0) DECIMAL(10) NOT NULL Transaction Identifier

55 WORKLISTNAME Character(30) VARCHAR2(30) NOT NULL Worklist Name

56 BUSPROCNAME Character(30) VARCHAR2(30) NOT NULL Business Process Name (see PSBUSPROCDEFN).

57 ACTIVITYNAME Character(30) VARCHAR2(30) NOT NULL Name of a Business Process Activity (see PSACTIVITYDEFN).

58 ACTION_DT_SS Date(10) DATE Termination Date

59 EXPIRATION_DATE Date(10) DATE Expiration Date

60 EXP_DT Date(10) DATE Expected Completion Date

61 ACTION Character(3) VARCHAR2(3) NOT NULL Action

62 ACTION_DATA_ENTRY Character(3) VARCHAR2(3) NOT NULL Data Entry
000=No Data Entry
128=Data Entry

63 COUNTRY_NM_FORMAT Character(3) VARCHAR2(3) NOT NULL Supported Name Format Types

64 NAME Character(50) VARCHAR2(50) NOT NULL Name

65 NAME_AC Character(50) VARCHAR2(50) NOT NULL Alternate Character Name

66 NAME_INITIALS Character(6) VARCHAR2(6) NOT NULL Name Initials

67 NAME_PREFIX Character(4) VARCHAR2(4) NOT NULL Name Prefix

68 NAME_ROYAL_PREFIX Character(15) VARCHAR2(15) NOT NULL Name Royal Prefix

69 NAME_ROYAL_SUFFIX Character(15) VARCHAR2(15) NOT NULL Name - Royal Suffix

70 NAME_SUFFIX Character(15) VARCHAR2(15) NOT NULL Name Suffix

71 NAME_TITLE Character(30) VARCHAR2(30) NOT NULL Name Title

72 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country

73 NAME_FORMAL Character(60) VARCHAR2(60) NOT NULL Formal Name - name formatted for Formal Display by COuntry. Normally used in Correspondence.

74 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name

75 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name

76 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name

77 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name

78 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL MIDDLE_NAME

79 SECOND_LAST_NAME Character(30) VARCHAR2(30) NOT NULL Second Last Name

80 SECOND_LAST_SRCH Character(30) VARCHAR2(30) NOT NULL Second Last Name

81 PREF_FIRST_NAME Character(30) VARCHAR2(30) NOT NULL Preferred First Name

82 PARTNER_LAST_NAME Character(30) VARCHAR2(30) NOT NULL The Partner Last Name is being used by the Netherlands for the employee name formatting, where a person can choose to use the partners last name as their prefered last name.

83 PARTNER_ROY_PREFIX Character(15) VARCHAR2(15) NOT NULL The Partner Royal Prefix is being used by the Netherlands for the employee name formatting, where a person can choose to use the partners last name and prefix as their prefered last name.

84 LAST_NAME_PREF_NLD Character(1) VARCHAR2(1) NOT NULL The field Last Name Preference is used in the Netherlands specific for people who are married to indicated their preference regarding the last name, which can be 4 choices based on the own last name and the partners last name.
1=Own Name
2=Name Partner
3=Name Partner + Own Name
4=Own Name + Name Partner

85 AE_TEST_FLAG Character(1) VARCHAR2(1) NOT NULL Test Flag

86 ENGINE_TYPE_CD Character(3) VARCHAR2(3) NOT NULL Engine Type
DIE=Diesel with cylinder capacity
OTH=Car without cylinder capacity
PET=Petrol with cylinder capacity

87 ENGINE_TYPE_L_DESC Character(45) VARCHAR2(45) NOT NULL Engine Type Long Description

88 ENGINE_TYPE_S_DESC Character(10) VARCHAR2(10) NOT NULL Engine Type Short Description

89 COUNTER Signed Number(6,0) DECIMAL(5) NOT NULL Counter

90 CODE Character(3) VARCHAR2(3) NOT NULL Generic field to represent a code (I bet you knew that)

91 UPG_NULL_DTTM DateTime(26) TIMESTAMP Date Time field with NULL value used during upgrades as default

92 UPG_NULL_TIME Time(15) TIMESTAMP Time field with NULL value used during upgrades as default

93 GROUP_ID Character(5) VARCHAR2(5) NOT NULL Group ID

94 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

95 COMP_FREQUENCY Character(5) VARCHAR2(5) NOT NULL Compensation Frequency
A=Annual
B=Biweekly
C=Contract
D=Daily
H=Hourly
M=Monthly
S=Semimonthly
W=Weekly

96 VC_PAYFORMULA_ID Character(10) VARCHAR2(10) NOT NULL Payout Formula ID

97 VC_PAYFORMULA_SQL Character(254) VARCHAR2(254) NOT NULL Pay Formula SQL

98 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

99 CHECK_CHAR Character(1) VARCHAR2(1) NOT NULL Check first byte &&return type

100 GPHK_TAX_REF_NUM Character(20) VARCHAR2(20) NOT NULL This field will contain the tax reference number that Hong Kong Pay entities are associated with.

101 NAME_TYPE Character(3) VARCHAR2(3) NOT NULL Type of Name

102 DEPENDENT_BENEF Character(2) VARCHAR2(2) NOT NULL Dependent Benefit
01=default

103 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

104 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

105 HPYP_CNTRL_AREA Character(5) VARCHAR2(5) NOT NULL Controlling Area

106 HPYP_CC_ID Character(12) VARCHAR2(12) NOT NULL Cost Center ID.

107 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

108 LABOR_AGREEMENT Character(6) VARCHAR2(6) NOT NULL Labor Agreement

109 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

110 HR_SUCC_PLAN_ID Character(11) VARCHAR2(11) NOT NULL Succession Plan ID

111 HR_SUCC_PLAN_TYPE Character(1) VARCHAR2(1) NOT NULL Succession Plan Type
1=Job Code
2=Person
3=Position

112 HR_SUCC_PLAN_CTL Character(11) VARCHAR2(11) NOT NULL Succession Plan Control Value

113 HR_SUCC_PLAN_STS Character(1) VARCHAR2(1) NOT NULL Succession Plan Status
D=Draft
I=Inactive
O=Official

114 NEXT_SUCCESSPLN_DT Date(10) DATE Next Succession Plan Date

115 AVAILABILITY_DT Date(10) DATE Availability Date

116 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

117 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	ADDR_FIELD1	Character(2)	VARCHAR2(2) NOT NULL	Address Field 1
3	ADDR_FIELD2	Character(4)	VARCHAR2(4) NOT NULL	Address Field 2
4	ADDR_FIELD3	Character(4)	VARCHAR2(4) NOT NULL	Address Field 3
5	ADDRESS_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Address Type
6	ADDRESS_TYPE_OTH	Character(4)	VARCHAR2(4) NOT NULL	Address Type
7	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
8	ADDRESS2	Character(55)	VARCHAR2(55) NOT NULL	Address 2
9	ADDRESS3	Character(55)	VARCHAR2(55) NOT NULL	Address 3
10	ADDRESS4	Character(55)	VARCHAR2(55) NOT NULL	Address 4
11	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
12	CITIZENSHIP_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Citizenship Status
13	COUNTY	Character(30)	VARCHAR2(30) NOT NULL	County
14	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
15	NUM2	Character(6)	VARCHAR2(6) NOT NULL	Number 2
16	NUM1	Character(6)	VARCHAR2(6) NOT NULL	Number 1
17	HOUSE_TYPE	Character(2)	VARCHAR2(2) NOT NULL	House Type AB=House Boat Reference WW=House Trailer Reference
18	GEO_CODE	Character(11)	VARCHAR2(11) NOT NULL	Geo Code
19	IN_CITY_LIMIT	Character(1)	VARCHAR2(1) NOT NULL	In City Limit
20	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
21	DATETIME_STAMP	DateTime(26)	TIMESTAMP	DateTime Stamp
22	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
23	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
24	EFFDT	Date(10)	DATE	Effective Date
25	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
26	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive
27	DUR	Date(10)	DATE	Date Under Report associates time being reported, scheduled or paid, to a specific date.
28	EXCEPTION_ID	Character(8)	VARCHAR2(8) NOT NULL	Exception ID
29	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
30	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
31	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
32	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
33	DESCR100	Character(100)	VARCHAR2(100) NOT NULL	Length 100 Description
34	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
35	DESCR254	Character(254)	VARCHAR2(254) NOT NULL	Description of length 254
36	REG_REGION	Character(5)	VARCHAR2(5) NOT NULL	Regulatory Region
37	ERNCD	Character(3)	VARCHAR2(3) NOT NULL	Earnings Code
38	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.
39	BENEFIT_PLAN	Character(6)	VARCHAR2(6) NOT NULL	Benefit Plan
40	PRIOR_EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Prior Emplid
41	PRIOR_EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Prior Employee Record Number
42	PRIOR_EFFDT	Date(10)	DATE	Prior Effective Date
43	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
44	LANG_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code CFR=Canadian French DAN=Danish DUT=Dutch ENG=English ESP=Spanish FRA=French GER=German GRK=Greek INE=International English ITA=Italian JPN=Japanese KOR=Korean POR=Portuguese SVE=Swedish THA=Thai ZHS=Simplified Chinese ZHT=Traditional Chinese
45	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
46	POSITION_NBR	Character(8)	VARCHAR2(8) NOT NULL	Position Number
47	CONTRACT_NBR_BEL	Number(3,0)	SMALLINT NOT NULL	Contract Seq. Number
48	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract Number
49	NULL_WORK_DATE	Date(10)	DATE	This field is used for the HRMS 8 Upgrade.
50	HIRE_DT	Date(10)	DATE	First Start Date
51	COMMENTS	Long Character	CLOB	Comment
52	EVENTNAME	Character(30)	VARCHAR2(30) NOT NULL	Defines a routing event for PS Workflow
53	INSTANCEID	Number(10,0)	DECIMAL(10) NOT NULL	For a given worklist the unique number of rows in PSWORKLIST
54	TRANSACTIONID	Number(10,0)	DECIMAL(10) NOT NULL	Transaction Identifier
55	WORKLISTNAME	Character(30)	VARCHAR2(30) NOT NULL	Worklist Name
56	BUSPROCNAME	Character(30)	VARCHAR2(30) NOT NULL	Business Process Name (see PSBUSPROCDEFN).
57	ACTIVITYNAME	Character(30)	VARCHAR2(30) NOT NULL	Name of a Business Process Activity (see PSACTIVITYDEFN).
58	ACTION_DT_SS	Date(10)	DATE	Termination Date
59	EXPIRATION_DATE	Date(10)	DATE	Expiration Date
60	EXP_DT	Date(10)	DATE	Expected Completion Date
61	ACTION	Character(3)	VARCHAR2(3) NOT NULL	Action
62	ACTION_DATA_ENTRY	Character(3)	VARCHAR2(3) NOT NULL	Data Entry 000=No Data Entry 128=Data Entry
63	COUNTRY_NM_FORMAT	Character(3)	VARCHAR2(3) NOT NULL	Supported Name Format Types
64	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
65	NAME_AC	Character(50)	VARCHAR2(50) NOT NULL	Alternate Character Name
66	NAME_INITIALS	Character(6)	VARCHAR2(6) NOT NULL	Name Initials
67	NAME_PREFIX	Character(4)	VARCHAR2(4) NOT NULL	Name Prefix
68	NAME_ROYAL_PREFIX	Character(15)	VARCHAR2(15) NOT NULL	Name Royal Prefix
69	NAME_ROYAL_SUFFIX	Character(15)	VARCHAR2(15) NOT NULL	Name - Royal Suffix
70	NAME_SUFFIX	Character(15)	VARCHAR2(15) NOT NULL	Name Suffix
71	NAME_TITLE	Character(30)	VARCHAR2(30) NOT NULL	Name Title
72	NAME_DISPLAY	Character(50)	VARCHAR2(50) NOT NULL	Display Name - name formatted for Display based on the Country
73	NAME_FORMAL	Character(60)	VARCHAR2(60) NOT NULL	Formal Name - name formatted for Formal Display by COuntry. Normally used in Correspondence.
74	FIRST_NAME_SRCH	Character(30)	VARCHAR2(30) NOT NULL	First Name
75	LAST_NAME_SRCH	Character(30)	VARCHAR2(30) NOT NULL	Last Name
76	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
77	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
78	MIDDLE_NAME	Character(30)	VARCHAR2(30) NOT NULL	MIDDLE_NAME
79	SECOND_LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Second Last Name
80	SECOND_LAST_SRCH	Character(30)	VARCHAR2(30) NOT NULL	Second Last Name
81	PREF_FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Preferred First Name
82	PARTNER_LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	The Partner Last Name is being used by the Netherlands for the employee name formatting, where a person can choose to use the partners last name as their prefered last name.
83	PARTNER_ROY_PREFIX	Character(15)	VARCHAR2(15) NOT NULL	The Partner Royal Prefix is being used by the Netherlands for the employee name formatting, where a person can choose to use the partners last name and prefix as their prefered last name.
84	LAST_NAME_PREF_NLD	Character(1)	VARCHAR2(1) NOT NULL	The field Last Name Preference is used in the Netherlands specific for people who are married to indicated their preference regarding the last name, which can be 4 choices based on the own last name and the partners last name. 1=Own Name 2=Name Partner 3=Name Partner + Own Name 4=Own Name + Name Partner
85	AE_TEST_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Test Flag
86	ENGINE_TYPE_CD	Character(3)	VARCHAR2(3) NOT NULL	Engine Type DIE=Diesel with cylinder capacity OTH=Car without cylinder capacity PET=Petrol with cylinder capacity
87	ENGINE_TYPE_L_DESC	Character(45)	VARCHAR2(45) NOT NULL	Engine Type Long Description
88	ENGINE_TYPE_S_DESC	Character(10)	VARCHAR2(10) NOT NULL	Engine Type Short Description
89	COUNTER	Signed Number(6,0)	DECIMAL(5) NOT NULL	Counter
90	CODE	Character(3)	VARCHAR2(3) NOT NULL	Generic field to represent a code (I bet you knew that)
91	UPG_NULL_DTTM	DateTime(26)	TIMESTAMP	Date Time field with NULL value used during upgrades as default
92	UPG_NULL_TIME	Time(15)	TIMESTAMP	Time field with NULL value used during upgrades as default
93	GROUP_ID	Character(5)	VARCHAR2(5) NOT NULL	Group ID
94	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
95	COMP_FREQUENCY	Character(5)	VARCHAR2(5) NOT NULL	Compensation Frequency A=Annual B=Biweekly C=Contract D=Daily H=Hourly M=Monthly S=Semimonthly W=Weekly
96	VC_PAYFORMULA_ID	Character(10)	VARCHAR2(10) NOT NULL	Payout Formula ID
97	VC_PAYFORMULA_SQL	Character(254)	VARCHAR2(254) NOT NULL	Pay Formula SQL
98	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
99	CHECK_CHAR	Character(1)	VARCHAR2(1) NOT NULL	Check first byte &&return type
100	GPHK_TAX_REF_NUM	Character(20)	VARCHAR2(20) NOT NULL	This field will contain the tax reference number that Hong Kong Pay entities are associated with.
101	NAME_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Type of Name
102	DEPENDENT_BENEF	Character(2)	VARCHAR2(2) NOT NULL	Dependent Benefit 01=default
103	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
104	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
105	HPYP_CNTRL_AREA	Character(5)	VARCHAR2(5) NOT NULL	Controlling Area
106	HPYP_CC_ID	Character(12)	VARCHAR2(12) NOT NULL	Cost Center ID.
107	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
108	LABOR_AGREEMENT	Character(6)	VARCHAR2(6) NOT NULL	Labor Agreement
109	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
110	HR_SUCC_PLAN_ID	Character(11)	VARCHAR2(11) NOT NULL	Succession Plan ID
111	HR_SUCC_PLAN_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Succession Plan Type 1=Job Code 2=Person 3=Position
112	HR_SUCC_PLAN_CTL	Character(11)	VARCHAR2(11) NOT NULL	Succession Plan Control Value
113	HR_SUCC_PLAN_STS	Character(1)	VARCHAR2(1) NOT NULL	Succession Plan Status D=Draft I=Inactive O=Official
114	NEXT_SUCCESSPLN_DT	Date(10)	DATE	Next Succession Plan Date
115	AVAILABILITY_DT	Date(10)	DATE	Availability Date
116	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
117	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.