UPG_APPV_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	HRS_PERSON_ID	Number(15,0)	DECIMAL(15) NOT NULL	Person Id
3	HRS_PROFILE_SEQ	Number(3,0)	SMALLINT NOT NULL	Profile sequece
4	HRS_SUBMITTED_BY	Character(15)	VARCHAR2(15) NOT NULL	submitted by
5	HRS_SUBMITTED_DTTM	DateTime(26)	TIMESTAMP	Submitted Date Time
6	HRS_RESUME_ID	Number(15,0)	DECIMAL(15) NOT NULL	Resume id
7	HRS_AL_LOG_ID	Number(15,0)	DECIMAL(15) NOT NULL	Resume Extraction Queue ID
8	APPLIC_PURGE_DT	Date(10)	DATE	Store date by which applicant records are to be deleted as part of the applicant purge process
9	HIGHEST_EDUC_LVL	Character(2)	VARCHAR2(2) NOT NULL	Highest Education Level
10	GVT_CRED_MIL_SVCE	Character(6)	VARCHAR2(6) NOT NULL	Creditable Military Service
11	GVT_MILITARY_COMP	Character(1)	VARCHAR2(1) NOT NULL	GVT_MILITARY_COMP A=Air Force C=Coast Guard M=Marines N=Navy R=Army
12	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
13	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
14	GVT_MIL_SEP_RET	Character(1)	VARCHAR2(1) NOT NULL	Military Separation Status R=Retired S=Separated Z=Not Applicable
15	GVT_MIL_SVCE_END	Date(10)	DATE	Military Service End Date
16	GVT_MIL_SVCE_START	Date(10)	DATE	Military Service Start Date
17	GVT_MIL_VERIFY	Character(1)	VARCHAR2(1) NOT NULL	Military Service Verified Y/N Table Edit
18	GVT_PAR_NBR_LAST	Number(6,0)	INTEGER NOT NULL	Last Personnel Action Reqst #
19	GVT_UNIF_SVC_CTR	Character(1)	VARCHAR2(1) NOT NULL	Notify Military Pay Center Y/N Table Edit
20	GVT_VET_PREF_APPT	Character(1)	VARCHAR2(1) NOT NULL	Veterans Preference Default Value: 1 Prompt Table: GVT_VETPREF_TBL
21	GVT_VET_PREF_RIF	Character(1)	VARCHAR2(1) NOT NULL	Veterans Preference RIF Y/N Table Edit Default Value: N
22	GVT_CHANGE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Change Flag
23	GVT_DRAFT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Draft Status N=Not Yet Registered R=Registered X=Not Applicable
24	GVT_YR_ATTAINED	Date(10)	DATE	Year Attained
25	DISABLED_VET	Character(1)	VARCHAR2(1) NOT NULL	Disabled Veteran
26	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 Prompt Table: GVT_HANDICP_TBL
27	ETHNIC_GROUP	Character(1)	VARCHAR2(1) NOT NULL	Ethnic Group 1=White 2=Black/African American 3=Hispanic/Latino 4=Asian 5=American Indian/Alaska Native 6=Not Applicable 7=Native Hawaiian/Oth Pac Island A=American Indian/Alaskan Native B=Asian or Pacific Islander C=Black, not of Hispanic origin D=Hispanic E=White, not of Hispanic origin F=Asian Indian G=Chinese H=Filipino J=Guamanian K=Hawaiian L=Japanese M=Korean N=Samoan P=Vietnamese Q=All Other Asian o Pacific Is Y=Not Hispanic in Puerto Rico Prompt Table: ETHNIC_GRP_TBL
28	GVT_DISABILITY_CD	Character(2)	VARCHAR2(2) NOT NULL	Disability Code Default Value: 05 Prompt Table: GVT_HANDICP_TBL
29	GRADE	Character(3)	VARCHAR2(3) NOT NULL	Salary Grade Prompt Table: %SAL_GRD_PRMPT1
30	SAL_ADMIN_PLAN	Character(4)	VARCHAR2(4) NOT NULL	Salary Administration Plan Default Value: 0000 Prompt Table: SAL_PLAN_TBL
31	GVT_CURR_AGCY_EMPL	Character(1)	VARCHAR2(1) NOT NULL	Current Agency Employee N=No Y=Yes Y/N Table Edit Default Value: N
32	GVT_CURR_FED_EMPL	Character(1)	VARCHAR2(1) NOT NULL	Current Federal Employee N=No Y=Yes Y/N Table Edit Default Value: N
33	GVT_HIGH_PAY_PLAN	Character(2)	VARCHAR2(2) NOT NULL	Highest Pay Plan Prompt Table: GVT_PAY_PLAN
34	GVT_HIGH_GRADE	Character(3)	VARCHAR2(3) NOT NULL	Highest Grade Prompt Table: %SAL_GRD_PRMPT3
35	GVT_PREV_AGCY_EMPL	Character(1)	VARCHAR2(1) NOT NULL	Previous Agency Employee N=No Y=Yes Y/N Table Edit Default Value: N
36	GVT_PREV_FED_EMPL	Character(1)	VARCHAR2(1) NOT NULL	Previous Federal Employee N=No Y=Yes Y/N Table Edit Default Value: N
37	GVT_SEP_INCENTIVE	Character(1)	VARCHAR2(1) NOT NULL	Separation Incentive B=Buyout/VSIP E=Early Retirement O=Other Incentive
38	GVT_SEP_INCENT_DT	Date(10)	DATE	Separation Incentive Date
39	GVT_TENURE	Character(1)	VARCHAR2(1) NOT NULL	Highest Career Tenure 0=None 1=Permanent 2=Conditional 3=Indefinite
40	GVT_PAY_PLAN	Character(2)	VARCHAR2(2) NOT NULL	Pay Plan Prompt Table: GVT_PAY_PLAN
41	BARG_UNIT	Character(4)	VARCHAR2(4) NOT NULL	Bargaining Unit 1=Bargaining Unit 1 2=Bargaining Unit 2
42	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
43	YEARS_OF_EXP	Number(5,1)	DECIMAL(4,1) NOT NULL	Years of Work Experience
44	LETTER_CD	Character(3)	VARCHAR2(3) NOT NULL	Letter code
45	LETTER_PRINTED_DT	Date(10)	DATE	Date letter was printed
46	TRAVELLING	Character(1)	VARCHAR2(1) NOT NULL	Willing to Travel N=No Y=Yes
47	RELOCATE	Character(1)	VARCHAR2(1) NOT NULL	Willing to Relocate N=No Y=Yes
48	UNION_CD	Character(3)	VARCHAR2(3) NOT NULL	Union Code
49	DESIRED_HOURS	Number(4,1)	DECIMAL(3,1) NOT NULL	Desired Hours Per Week
50	MIN_RATE	Number(19,6)	DECIMAL(18,6) NOT NULL	Minimum Acceptable Pay Rate
51	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
52	PAY_FREQ_ABBRV	Character(1)	VARCHAR2(1) NOT NULL	Pay Frequency A=Annual B=Bi-weeky H=Hour M=Month Y=Year
53	DESIRED_START_DT	Date(10)	DATE	Desired Start Date
54	DESIRED_FULL_PART	Character(1)	VARCHAR2(1) NOT NULL	Full/Part-Time E=Either F=Full-Time P=Part-Time
55	DESIRED_REG_TEMP	Character(1)	VARCHAR2(1) NOT NULL	Regular/Temporary E=Either R=Regular T=Temporary
56	DESIRED_SHIFT	Character(1)	VARCHAR2(1) NOT NULL	Desired Shift 1=1 2=2 3=3 A=Any C=Compressed N=Not Applicable R=Rotating
57	MON	Character(1)	VARCHAR2(1) NOT NULL	Monday
58	TUES	Character(1)	VARCHAR2(1) NOT NULL	Tuesday
59	WED	Character(1)	VARCHAR2(1) NOT NULL	Wednesday
60	THURS	Character(1)	VARCHAR2(1) NOT NULL	Thursday
61	FRI	Character(1)	VARCHAR2(1) NOT NULL	Friday
62	SAT	Character(1)	VARCHAR2(1) NOT NULL	Saturday
63	SUN	Character(1)	VARCHAR2(1) NOT NULL	Sunday
64	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
65	DESIRED_LOCATN1	Character(10)	VARCHAR2(10) NOT NULL	First Choice
66	DESIRED_LOCATN2	Character(10)	VARCHAR2(10) NOT NULL	Second Choice
67	HRS_DES_LOC1	Number(15,0)	DECIMAL(15) NOT NULL	Desired Location 1
68	HRS_DES_LOC2	Number(15,0)	DECIMAL(15) NOT NULL	Desired Location 2
69	TRAVEL_PERCENT	Number(3,0)	SMALLINT NOT NULL	Percentage Travel
70	HRS_ROW_ADD_DTTM	DateTime(26)	TIMESTAMP	Row Added DateTime
71	HRS_ROW_ADD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Row Added Operator Id
72	HRS_ROW_UPD_DTTM	DateTime(26)	TIMESTAMP	Row Updated DateTime
73	HRS_ROW_UPD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Row Updated Operator Id
74	GEOG_PREFER	Long Character	CLOB	Geographic Preference