UPG_HRS_APP_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	AE_SECTION	Character(8)	VARCHAR2(8) NOT NULL	Section
4	AE_STEP	Character(8)	VARCHAR2(8) NOT NULL	Name
5	EFFDT	Date(10)	DATE	Effective Date
6	RESUME_TEXT	Long Character	CLOB	Resume text
7	RESUME_NUMBER	Number(7,0)	INTEGER NOT NULL	Resume number
8	URL_1	Character(254)	VARCHAR2(254) NOT NULL	URL #1
9	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
10	ATTACHSYSFILENAME	Character(128)	VARCHAR2(128) NOT NULL	Unique Sys Filename
11	ACCOMPLISHMENT	Character(8)	VARCHAR2(8) NOT NULL	Accomplishment
12	NULL_WORK_DATE	Date(10)	DATE	This field is used for the HRMS 8 Upgrade.
13	MAJOR_CODE	Character(10)	VARCHAR2(10) NOT NULL	Major Code
14	EVALUATION_ID	Character(2)	VARCHAR2(2) NOT NULL	Evaluation ID
15	COMPETENCY	Character(8)	VARCHAR2(8) NOT NULL	Competency
16	ATTACHUSERFILE	Character(64)	VARCHAR2(64) NOT NULL	Attached File
17	APPLID	Character(11)	VARCHAR2(11) NOT NULL	External Job Applicant ID
18	HRS_PERSON_ID	Number(15,0)	DECIMAL(15) NOT NULL	Person Id
19	HRS_SUBMITTED_DTTM	DateTime(26)	TIMESTAMP	Submitted Date Time
20	HRS_E_ADDR_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Address Type 0000=Select... BUSN=Business CAMP=Campus DORM=Dormitory HOME=Home OTHR=Other
21	APP_DT	Date(10)	DATE	Date an application was submitted
22	HRS_PROFILE_SEQ	Number(3,0)	SMALLINT NOT NULL	Profile sequece
23	HRS_PHONE_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Phone Type 0000=Select... BUSN=Business CAMP=Campus CELL=Cellular DORM=Dormitory FAX=Fax HOME=Home MAIN=Main OTR=Other PGR1=Pager 1 PGR2=Pager 2 TELX=Telex
24	HRS_PROXY_ID	Number(15,0)	DECIMAL(15) NOT NULL	Proxy Id
25	EMAIL_ADDR	Character(70)	VARCHAR2(70) NOT NULL	Email Address
26	HRS_OPRPSWD	Character(32)	VARCHAR2(32) NOT NULL	User Password
27	DATETIME_STAMP	DateTime(26)	TIMESTAMP	DateTime Stamp
28	HRS_SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
29	HRS_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
30	PGM_FLOW_CNTL	Character(1)	VARCHAR2(1) NOT NULL	Convenient AE State Record field for receiving result of a Do-When, Do-While, Do-Until, or other program flow control flag.
31	SQL_ROW_COUNT	Number(8,0)	INTEGER NOT NULL	Convenient AE State Record field for managing the count of affected rows when %SQLRows is not applicable.
32	MESSAGE_SET_NBR	Number(5,0)	INTEGER NOT NULL	Message Set Number. This field refers to the Message Set Number in the Message Catalog.
33	MESSAGE_NBR	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog.
34	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
35	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
36	DESIRED_LOCATN1	Character(10)	VARCHAR2(10) NOT NULL	First Choice
37	DESIRED_LOCATN2	Character(10)	VARCHAR2(10) NOT NULL	Second Choice
38	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
39	HRS_AL_LOG_ID	Number(15,0)	DECIMAL(15) NOT NULL	Resume Extraction Queue ID
40	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
41	NATIONAL_ID_TYPE	Character(6)	VARCHAR2(6) NOT NULL	National ID Type
42	NID_EXPIRY_DATE	Date(10)	DATE	National ID Expiry Date
43	HRS_LOCATION_ID	Number(15,0)	DECIMAL(15) NOT NULL	Recruiting location area
44	INTVW_CATEGORY	Number(2,0)	SMALLINT NOT NULL	Interview Category
45	HRS_RESUME_TITLE	Character(60)	VARCHAR2(60) NOT NULL	Profile ID