PERSONNEL_RPT (SQL View)	Index Back
Personnell Rpt Snapshot Snapshot record for reporting use only. This is loaded by an AE with data from the core records ASOF the date entered on the runcontrol. This Record Cannot be used online - it should only be used by reporting. With the knowledge of what the ASOFDATE is at the time of the run.

PERSONNEL_RPT

(SQL View)

Personnell Rpt Snapshot

Snapshot record for reporting use only. This is loaded by an AE with data from the core records ASOF the date entered on the runcontrol. This Record Cannot be used online - it should only be used by reporting. With the knowledge of what the ASOFDATE is at the time of the run.

SELECT EMPLID , COUNTRY_NM_FORMAT , NAME , NAME_INITIALS , NAME_PREFIX , NAME_SUFFIX , NAME_ROYAL_PREFIX , NAME_ROYAL_SUFFIX , NAME_TITLE , LAST_NAME_SRCH , FIRST_NAME_SRCH , LAST_NAME , FIRST_NAME , MIDDLE_NAME , SECOND_LAST_NAME , SECOND_LAST_SRCH , NAME_AC , PREF_FIRST_NAME , PARTNER_LAST_NAME , PARTNER_ROY_PREFIX , LAST_NAME_PREF_NLD , NAME_DISPLAY , NAME_FORMAL , COUNTRY , ADDRESS1 , ADDRESS2 , ADDRESS3 , ADDRESS4 , CITY , NUM1 , NUM2 , HOUSE_TYPE , ADDR_FIELD1 , ADDR_FIELD2 , ADDR_FIELD3 , COUNTY , STATE , POSTAL , GEO_CODE , IN_CITY_LIMIT , SEX , MAR_STATUS , MAR_STATUS_DT , BIRTHDATE , BIRTHPLACE , BIRTHCOUNTRY , BIRTHSTATE , DT_OF_DEATH , FT_STUDENT , US_WORK_ELIGIBILTY , MILITARY_STATUS , CITIZEN_PROOF1 , CITIZEN_PROOF2 , SMOKER , MEDICARE_ENTLD_DT , SMOKER_DT , BILINGUALISM_CODE , HEALTH_CARE_NBR , HEALTH_CARE_STATE , LANG_CD , GVT_CRED_MIL_SVCE , GVT_MILITARY_COMP , GVT_MIL_GRADE , GVT_MIL_RESRVE_CAT , GVT_MIL_SEP_RET , GVT_MIL_SVCE_END , GVT_MIL_SVCE_START , GVT_MIL_VERIFY , GVT_PAR_NBR_LAST , GVT_UNIF_SVC_CTR , GVT_VET_PREF_APPT , GVT_VET_PREF_RIF , GVT_CHANGE_FLAG , GVT_DRAFT_STATUS , GVT_YR_ATTAINED , DISABLED_VET , DISABLED , GVT_DISABILITY_CD , GRADE , SAL_ADMIN_PLAN , GVT_CURR_AGCY_EMPL , GVT_CURR_FED_EMPL , GVT_HIGH_PAY_PLAN , GVT_HIGH_GRADE , GVT_PREV_AGCY_EMPL , GVT_PREV_FED_EMPL , GVT_SEP_INCENTIVE , GVT_SEP_INCENT_DT , GVT_TENURE , GVT_PAY_PLAN , BARG_UNIT , ALTER_EMPLID , ADDRESS1_AC , ADDRESS2_AC , ADDRESS3_AC , CITY_AC , PHONE FROM PS_PERSONAL_DATA

Parent record: PERSON

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Default Value: NEW

2 COUNTRY_NM_FORMAT Character(3) VARCHAR2(3) NOT NULL Supported Name Format Types
Prompt Table: NAME_FORMAT_TBL

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

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

5 NAME_PREFIX Character(4) VARCHAR2(4) NOT NULL Name Prefix
Prompt Table: NAME_PREFIX_TBL

6 NAME_SUFFIX Character(15) VARCHAR2(15) NOT NULL Name Suffix
Prompt Table: NAME_SUFFIX_TBL

7 NAME_ROYAL_PREFIX Character(15) VARCHAR2(15) NOT NULL Name Royal Prefix
Prompt Table: NM_ROYPREF_GBL

8 NAME_ROYAL_SUFFIX Character(15) VARCHAR2(15) NOT NULL Name - Royal Suffix
Prompt Table: NM_ROYSUFF_GBL

9 NAME_TITLE Character(30) VARCHAR2(30) NOT NULL Name Title
Prompt Table: TITLE_TBL

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

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

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

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

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

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

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

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

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

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

20 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.
Prompt Table: NM_ROYPREF_GBL

21 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
Default Value: 1

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

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

24 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
Prompt Table: COUNTRY_TBL

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

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

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

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

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

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

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

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

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

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

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

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

37 STATE Character(6) VARCHAR2(6) NOT NULL State
Prompt Table: STATE_TBL

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

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

40 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit
Y/N Table Edit

41 SEX Character(1) VARCHAR2(1) NOT NULL Gender
F=Female
M=Male
U=Unknown

42 MAR_STATUS Character(1) VARCHAR2(1) NOT NULL Marital Status
C=Common-Law
D=Divorced
E=Separated
H=Head of Household
L=DissDeclLost Civil Partner
M=Married
P=Civil Partnership
S=Single
T=Surviving Civil Partner
U=Unknown
V=Dissolved Civil Partnership
W=Widowed

43 MAR_STATUS_DT Date(10) DATE This is the date that the employee's Marital status is/was effective. /* Marital Status date is stored redundantly on PERS_DATA_EFFDT for two reasons. 1. To allow the date to be entered prior to the first PERS_DATA_EFFDT so that the actual date for the marital status on the hire row can be entered. This is the only time that the field is enterable by the user. 2. To allow for easier reporting on the data via SQR and Crystal. This is denormalizing the PERS_DATA_EFFDT record, but the number of requests for this redundancy coupled with the need for #1, has provided the justification for denormalizing this information and taking on the added maintenance. */

44 BIRTHDATE Date(10) DATE Date of Birth

45 BIRTHPLACE Character(30) VARCHAR2(30) NOT NULL Birth Location

46 BIRTHCOUNTRY Character(3) VARCHAR2(3) NOT NULL Birth Country
Prompt Table: COUNTRY_TBL

47 BIRTHSTATE Character(6) VARCHAR2(6) NOT NULL Birth State
Prompt Table: BIRTHSTATE_VW

48 DT_OF_DEATH Date(10) DATE Date of Death

49 FT_STUDENT Character(1) VARCHAR2(1) NOT NULL Full-Time Student
Y/N Table Edit

50 US_WORK_ELIGIBILTY Character(1) VARCHAR2(1) NOT NULL Eligible to Work in U.S.
N=No
Y=Yes
Y/N Table Edit
Default Value: Y

51 MILITARY_STATUS Character(1) VARCHAR2(1) NOT NULL Veteran Status / Military Status
Default Value: 1

52 CITIZEN_PROOF1 Character(10) VARCHAR2(10) NOT NULL Citizenship (Proof 1)

53 CITIZEN_PROOF2 Character(10) VARCHAR2(10) NOT NULL Citizenship (Proof 2)

54 SMOKER Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not (Y or N) an employee or dependent is a smoker.
N=Non Smoker
Y=Smoker
Y/N Table Edit
Default Value: N

55 MEDICARE_ENTLD_DT Date(10) DATE Date Entitled to Medicare

56 SMOKER_DT Date(10) DATE Smoker Status Date

57 BILINGUALISM_CODE Character(1) VARCHAR2(1) NOT NULL Bilingualism Code
1=Not Bilingual
2=Bilingual
3=Receptive Skills Only
9=Unknown

58 HEALTH_CARE_NBR Character(12) VARCHAR2(12) NOT NULL Health Care Number

59 HEALTH_CARE_STATE Character(6) VARCHAR2(6) NOT NULL Health Care Province
Prompt Table: PROVINCE_NM_VW

60 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

61 GVT_CRED_MIL_SVCE Character(6) VARCHAR2(6) NOT NULL Creditable Military Service

62 GVT_MILITARY_COMP Character(1) VARCHAR2(1) NOT NULL GVT_MILITARY_COMP
A=Air Force
C=Coast Guard
M=Marines
N=Navy
R=Army

63 GVT_MIL_GRADE Character(3) VARCHAR2(3) NOT NULL Military Grade
E1=E1
E2=E2
E3=E3
E4=E4
E5=E5
E6=E6
E7=E7
E8=E8
E9=E9
O1=O1
O10=O10
O2=O2
O3=O3
O4=O4
O5=O5
O6=O6
O7=O7
O8=O8
O9=O9
W1=W1
W2=W2
W3=W3
W4=W4

64 GVT_MIL_RESRVE_CAT Character(1) VARCHAR2(1) NOT NULL Reserve Category
A=IMA - Air Force
B=IMA - Army
C=IMA - Coast Guard
D=IMA - Marines
E=IMA - Navy
F=Selected Reserve - Air Force
G=Selected Reserve - Army
H=Selected Reserve - Coast Guard
I=Selected Reserve - Marine Corp
J=Selected Reserves - Navy
K=Air National Guard
L=Army National Guard
M=IRR - Air Force
N=IRR - Army
O=IRR - Coast Guard
P=IRR - Marine Corps
Q=IRR - Navy
S=Standby Reserve - Air Force
T=Standby Reserve - Army
U=Standby Reserve - Coast Guard
V=Standby Reserve - Marine Corps
W=Standby Reserve - Navy
X=Navy Reserve - Merchant Marine
Y=Draft Eligible
Z=Not Applicable

65 GVT_MIL_SEP_RET Character(1) VARCHAR2(1) NOT NULL Military Separation Status
R=Retired
S=Separated
Z=Not Applicable

66 GVT_MIL_SVCE_END Date(10) DATE Military Service End Date

67 GVT_MIL_SVCE_START Date(10) DATE Military Service Start Date

68 GVT_MIL_VERIFY Character(1) VARCHAR2(1) NOT NULL Military Service Verified

69 GVT_PAR_NBR_LAST Number(6,0) INTEGER NOT NULL Last Personnel Action Reqst #

70 GVT_UNIF_SVC_CTR Character(1) VARCHAR2(1) NOT NULL Notify Military Pay Center

71 GVT_VET_PREF_APPT Character(1) VARCHAR2(1) NOT NULL Veterans Preference

72 GVT_VET_PREF_RIF Character(1) VARCHAR2(1) NOT NULL Veterans Preference RIF
Default Value: N

73 GVT_CHANGE_FLAG Character(1) VARCHAR2(1) NOT NULL Change Flag

74 GVT_DRAFT_STATUS Character(1) VARCHAR2(1) NOT NULL Draft Status
N=Not Yet Registered
R=Registered
X=Not Applicable

75 GVT_YR_ATTAINED Date(10) DATE Year Attained

76 DISABLED_VET Character(1) VARCHAR2(1) NOT NULL Disabled Veteran
Y/N Table Edit

77 DISABLED Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not (Y or N) a dependent is a disabled.
Default Value: N

78 GVT_DISABILITY_CD Character(2) VARCHAR2(2) NOT NULL Disability Code
Default Value: 05

79 GRADE Character(3) VARCHAR2(3) NOT NULL Salary Grade

80 SAL_ADMIN_PLAN Character(4) VARCHAR2(4) NOT NULL Salary Administration Plan
Default Value: 0000

81 GVT_CURR_AGCY_EMPL Character(1) VARCHAR2(1) NOT NULL Current Agency Employee
N=No
Y=Yes
Y/N Table Edit
Default Value: N

82 GVT_CURR_FED_EMPL Character(1) VARCHAR2(1) NOT NULL Current Federal Employee
N=No
Y=Yes
Y/N Table Edit
Default Value: N

83 GVT_HIGH_PAY_PLAN Character(2) VARCHAR2(2) NOT NULL Highest Pay Plan

84 GVT_HIGH_GRADE Character(3) VARCHAR2(3) NOT NULL Highest Grade

85 GVT_PREV_AGCY_EMPL Character(1) VARCHAR2(1) NOT NULL Previous Agency Employee
N=No
Y=Yes
Y/N Table Edit
Default Value: N

86 GVT_PREV_FED_EMPL Character(1) VARCHAR2(1) NOT NULL Previous Federal Employee
N=No
Y=Yes
Y/N Table Edit
Default Value: N

87 GVT_SEP_INCENTIVE Character(1) VARCHAR2(1) NOT NULL Separation Incentive
B=Buyout/VSIP
E=Early Retirement
O=Other Incentive

88 GVT_SEP_INCENT_DT Date(10) DATE Separation Incentive Date

89 GVT_TENURE Character(1) VARCHAR2(1) NOT NULL Highest Career Tenure
0=None
1=Permanent
2=Conditional
3=Indefinite

90 GVT_PAY_PLAN Character(2) VARCHAR2(2) NOT NULL Pay Plan

91 BARG_UNIT Character(4) VARCHAR2(4) NOT NULL Bargaining Unit
1=Bargaining Unit 1
2=Bargaining Unit 2

92 ALTER_EMPLID Character(11) VARCHAR2(11) NOT NULL Alternate Employee ID

93 ADDRESS1_AC Character(55) VARCHAR2(55) NOT NULL Alternate Character Address 1

94 ADDRESS2_AC Character(55) VARCHAR2(55) NOT NULL Alternate Character Address 2

95 ADDRESS3_AC Character(55) VARCHAR2(55) NOT NULL Alternate Character Address 3

96 CITY_AC Character(30) VARCHAR2(30) NOT NULL Alternate Character City

97 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Default Value: NEW
2	COUNTRY_NM_FORMAT	Character(3)	VARCHAR2(3) NOT NULL	Supported Name Format Types Prompt Table: NAME_FORMAT_TBL
3	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
4	NAME_INITIALS	Character(6)	VARCHAR2(6) NOT NULL	Name Initials
5	NAME_PREFIX	Character(4)	VARCHAR2(4) NOT NULL	Name Prefix Prompt Table: NAME_PREFIX_TBL
6	NAME_SUFFIX	Character(15)	VARCHAR2(15) NOT NULL	Name Suffix Prompt Table: NAME_SUFFIX_TBL
7	NAME_ROYAL_PREFIX	Character(15)	VARCHAR2(15) NOT NULL	Name Royal Prefix Prompt Table: NM_ROYPREF_GBL
8	NAME_ROYAL_SUFFIX	Character(15)	VARCHAR2(15) NOT NULL	Name - Royal Suffix Prompt Table: NM_ROYSUFF_GBL
9	NAME_TITLE	Character(30)	VARCHAR2(30) NOT NULL	Name Title Prompt Table: TITLE_TBL
10	LAST_NAME_SRCH	Character(30)	VARCHAR2(30) NOT NULL	Last Name
11	FIRST_NAME_SRCH	Character(30)	VARCHAR2(30) NOT NULL	First Name
12	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
13	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
14	MIDDLE_NAME	Character(30)	VARCHAR2(30) NOT NULL	MIDDLE_NAME
15	SECOND_LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Second Last Name
16	SECOND_LAST_SRCH	Character(30)	VARCHAR2(30) NOT NULL	Second Last Name
17	NAME_AC	Character(50)	VARCHAR2(50) NOT NULL	Alternate Character Name
18	PREF_FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Preferred First Name
19	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.
20	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. Prompt Table: NM_ROYPREF_GBL
21	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 Default Value: 1
22	NAME_DISPLAY	Character(50)	VARCHAR2(50) NOT NULL	Display Name - name formatted for Display based on the Country
23	NAME_FORMAL	Character(60)	VARCHAR2(60) NOT NULL	Formal Name - name formatted for Formal Display by COuntry. Normally used in Correspondence.
24	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: COUNTRY_TBL
25	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
26	ADDRESS2	Character(55)	VARCHAR2(55) NOT NULL	Address 2
27	ADDRESS3	Character(55)	VARCHAR2(55) NOT NULL	Address 3
28	ADDRESS4	Character(55)	VARCHAR2(55) NOT NULL	Address 4
29	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
30	NUM1	Character(6)	VARCHAR2(6) NOT NULL	Number 1
31	NUM2	Character(6)	VARCHAR2(6) NOT NULL	Number 2
32	HOUSE_TYPE	Character(2)	VARCHAR2(2) NOT NULL	House Type AB=House Boat Reference WW=House Trailer Reference
33	ADDR_FIELD1	Character(2)	VARCHAR2(2) NOT NULL	Address Field 1
34	ADDR_FIELD2	Character(4)	VARCHAR2(4) NOT NULL	Address Field 2
35	ADDR_FIELD3	Character(4)	VARCHAR2(4) NOT NULL	Address Field 3
36	COUNTY	Character(30)	VARCHAR2(30) NOT NULL	County
37	STATE	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: STATE_TBL
38	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
39	GEO_CODE	Character(11)	VARCHAR2(11) NOT NULL	Geo Code
40	IN_CITY_LIMIT	Character(1)	VARCHAR2(1) NOT NULL	In City Limit Y/N Table Edit
41	SEX	Character(1)	VARCHAR2(1) NOT NULL	Gender F=Female M=Male U=Unknown
42	MAR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Marital Status C=Common-Law D=Divorced E=Separated H=Head of Household L=DissDeclLost Civil Partner M=Married P=Civil Partnership S=Single T=Surviving Civil Partner U=Unknown V=Dissolved Civil Partnership W=Widowed
43	MAR_STATUS_DT	Date(10)	DATE	This is the date that the employee's Marital status is/was effective. /* Marital Status date is stored redundantly on PERS_DATA_EFFDT for two reasons. 1. To allow the date to be entered prior to the first PERS_DATA_EFFDT so that the actual date for the marital status on the hire row can be entered. This is the only time that the field is enterable by the user. 2. To allow for easier reporting on the data via SQR and Crystal. This is denormalizing the PERS_DATA_EFFDT record, but the number of requests for this redundancy coupled with the need for #1, has provided the justification for denormalizing this information and taking on the added maintenance. */
44	BIRTHDATE	Date(10)	DATE	Date of Birth
45	BIRTHPLACE	Character(30)	VARCHAR2(30) NOT NULL	Birth Location
46	BIRTHCOUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Birth Country Prompt Table: COUNTRY_TBL
47	BIRTHSTATE	Character(6)	VARCHAR2(6) NOT NULL	Birth State Prompt Table: BIRTHSTATE_VW
48	DT_OF_DEATH	Date(10)	DATE	Date of Death
49	FT_STUDENT	Character(1)	VARCHAR2(1) NOT NULL	Full-Time Student Y/N Table Edit
50	US_WORK_ELIGIBILTY	Character(1)	VARCHAR2(1) NOT NULL	Eligible to Work in U.S. N=No Y=Yes Y/N Table Edit Default Value: Y
51	MILITARY_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Veteran Status / Military Status Default Value: 1
52	CITIZEN_PROOF1	Character(10)	VARCHAR2(10) NOT NULL	Citizenship (Proof 1)
53	CITIZEN_PROOF2	Character(10)	VARCHAR2(10) NOT NULL	Citizenship (Proof 2)
54	SMOKER	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates whether or not (Y or N) an employee or dependent is a smoker. N=Non Smoker Y=Smoker Y/N Table Edit Default Value: N
55	MEDICARE_ENTLD_DT	Date(10)	DATE	Date Entitled to Medicare
56	SMOKER_DT	Date(10)	DATE	Smoker Status Date
57	BILINGUALISM_CODE	Character(1)	VARCHAR2(1) NOT NULL	Bilingualism Code 1=Not Bilingual 2=Bilingual 3=Receptive Skills Only 9=Unknown
58	HEALTH_CARE_NBR	Character(12)	VARCHAR2(12) NOT NULL	Health Care Number
59	HEALTH_CARE_STATE	Character(6)	VARCHAR2(6) NOT NULL	Health Care Province Prompt Table: PROVINCE_NM_VW
60	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
61	GVT_CRED_MIL_SVCE	Character(6)	VARCHAR2(6) NOT NULL	Creditable Military Service
62	GVT_MILITARY_COMP	Character(1)	VARCHAR2(1) NOT NULL	GVT_MILITARY_COMP A=Air Force C=Coast Guard M=Marines N=Navy R=Army
63	GVT_MIL_GRADE	Character(3)	VARCHAR2(3) NOT NULL	Military Grade E1=E1 E2=E2 E3=E3 E4=E4 E5=E5 E6=E6 E7=E7 E8=E8 E9=E9 O1=O1 O10=O10 O2=O2 O3=O3 O4=O4 O5=O5 O6=O6 O7=O7 O8=O8 O9=O9 W1=W1 W2=W2 W3=W3 W4=W4
64	GVT_MIL_RESRVE_CAT	Character(1)	VARCHAR2(1) NOT NULL	Reserve Category A=IMA - Air Force B=IMA - Army C=IMA - Coast Guard D=IMA - Marines E=IMA - Navy F=Selected Reserve - Air Force G=Selected Reserve - Army H=Selected Reserve - Coast Guard I=Selected Reserve - Marine Corp J=Selected Reserves - Navy K=Air National Guard L=Army National Guard M=IRR - Air Force N=IRR - Army O=IRR - Coast Guard P=IRR - Marine Corps Q=IRR - Navy S=Standby Reserve - Air Force T=Standby Reserve - Army U=Standby Reserve - Coast Guard V=Standby Reserve - Marine Corps W=Standby Reserve - Navy X=Navy Reserve - Merchant Marine Y=Draft Eligible Z=Not Applicable
65	GVT_MIL_SEP_RET	Character(1)	VARCHAR2(1) NOT NULL	Military Separation Status R=Retired S=Separated Z=Not Applicable
66	GVT_MIL_SVCE_END	Date(10)	DATE	Military Service End Date
67	GVT_MIL_SVCE_START	Date(10)	DATE	Military Service Start Date
68	GVT_MIL_VERIFY	Character(1)	VARCHAR2(1) NOT NULL	Military Service Verified
69	GVT_PAR_NBR_LAST	Number(6,0)	INTEGER NOT NULL	Last Personnel Action Reqst #
70	GVT_UNIF_SVC_CTR	Character(1)	VARCHAR2(1) NOT NULL	Notify Military Pay Center
71	GVT_VET_PREF_APPT	Character(1)	VARCHAR2(1) NOT NULL	Veterans Preference
72	GVT_VET_PREF_RIF	Character(1)	VARCHAR2(1) NOT NULL	Veterans Preference RIF Default Value: N
73	GVT_CHANGE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Change Flag
74	GVT_DRAFT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Draft Status N=Not Yet Registered R=Registered X=Not Applicable
75	GVT_YR_ATTAINED	Date(10)	DATE	Year Attained
76	DISABLED_VET	Character(1)	VARCHAR2(1) NOT NULL	Disabled Veteran Y/N Table Edit
77	DISABLED	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates whether or not (Y or N) a dependent is a disabled. Default Value: N
78	GVT_DISABILITY_CD	Character(2)	VARCHAR2(2) NOT NULL	Disability Code Default Value: 05
79	GRADE	Character(3)	VARCHAR2(3) NOT NULL	Salary Grade
80	SAL_ADMIN_PLAN	Character(4)	VARCHAR2(4) NOT NULL	Salary Administration Plan Default Value: 0000
81	GVT_CURR_AGCY_EMPL	Character(1)	VARCHAR2(1) NOT NULL	Current Agency Employee N=No Y=Yes Y/N Table Edit Default Value: N
82	GVT_CURR_FED_EMPL	Character(1)	VARCHAR2(1) NOT NULL	Current Federal Employee N=No Y=Yes Y/N Table Edit Default Value: N
83	GVT_HIGH_PAY_PLAN	Character(2)	VARCHAR2(2) NOT NULL	Highest Pay Plan
84	GVT_HIGH_GRADE	Character(3)	VARCHAR2(3) NOT NULL	Highest Grade
85	GVT_PREV_AGCY_EMPL	Character(1)	VARCHAR2(1) NOT NULL	Previous Agency Employee N=No Y=Yes Y/N Table Edit Default Value: N
86	GVT_PREV_FED_EMPL	Character(1)	VARCHAR2(1) NOT NULL	Previous Federal Employee N=No Y=Yes Y/N Table Edit Default Value: N
87	GVT_SEP_INCENTIVE	Character(1)	VARCHAR2(1) NOT NULL	Separation Incentive B=Buyout/VSIP E=Early Retirement O=Other Incentive
88	GVT_SEP_INCENT_DT	Date(10)	DATE	Separation Incentive Date
89	GVT_TENURE	Character(1)	VARCHAR2(1) NOT NULL	Highest Career Tenure 0=None 1=Permanent 2=Conditional 3=Indefinite
90	GVT_PAY_PLAN	Character(2)	VARCHAR2(2) NOT NULL	Pay Plan
91	BARG_UNIT	Character(4)	VARCHAR2(4) NOT NULL	Bargaining Unit 1=Bargaining Unit 1 2=Bargaining Unit 2
92	ALTER_EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Alternate Employee ID
93	ADDRESS1_AC	Character(55)	VARCHAR2(55) NOT NULL	Alternate Character Address 1
94	ADDRESS2_AC	Character(55)	VARCHAR2(55) NOT NULL	Alternate Character Address 2
95	ADDRESS3_AC	Character(55)	VARCHAR2(55) NOT NULL	Alternate Character Address 3
96	CITY_AC	Character(30)	VARCHAR2(30) NOT NULL	Alternate Character City
97	PHONE	Character(24)	VARCHAR2(24) NOT NULL	Telephone