UPG_HRS_OI_AET

(SQL Table)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename

3 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File

4 FILE_SEQ Number(9,0) DECIMAL(9) NOT NULL File Sequence Number

5 VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference

6 FILE_SIZE Number(10,0) DECIMAL(10) NOT NULL Physical File Size

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

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

9 ACCOMPLISHMENT_TXT Character(30) VARCHAR2(30) NOT NULL Accomplishment Text

10 ACCOMPLISHMENT Character(8) VARCHAR2(8) NOT NULL Accomplishment

11 HRS_DM_VAL_ID Number(15,0) DECIMAL(15) NOT NULL Data Mapping Value ID.

12 HRS_DM_KEY_ID Number(15,0) DECIMAL(15) NOT NULL Data Mapping Key ID

13 HRS_DM_CAT_ID Number(15,0) DECIMAL(15) NOT NULL Data Mapping Category ID

14 ACCOMP_CATEGORY Character(3) VARCHAR2(3) NOT NULL Accomplishment Category
DEG=Degree
HON=Honor or Award
LIC=License or Certification
LNG=Language
MEM=Membership
NVQ=NVQ
TST=Test

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	ATTACHSYSFILENAME	Character(128)	VARCHAR2(128) NOT NULL	Unique Sys Filename
3	ATTACHUSERFILE	Character(64)	VARCHAR2(64) NOT NULL	Attached File
4	FILE_SEQ	Number(9,0)	DECIMAL(9) NOT NULL	File Sequence Number
5	VERSION	Number(10,0)	DECIMAL(10) NOT NULL	Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
6	FILE_SIZE	Number(10,0)	DECIMAL(10) NOT NULL	Physical File Size
7	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.
8	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.
9	ACCOMPLISHMENT_TXT	Character(30)	VARCHAR2(30) NOT NULL	Accomplishment Text
10	ACCOMPLISHMENT	Character(8)	VARCHAR2(8) NOT NULL	Accomplishment
11	HRS_DM_VAL_ID	Number(15,0)	DECIMAL(15) NOT NULL	Data Mapping Value ID.
12	HRS_DM_KEY_ID	Number(15,0)	DECIMAL(15) NOT NULL	Data Mapping Key ID
13	HRS_DM_CAT_ID	Number(15,0)	DECIMAL(15) NOT NULL	Data Mapping Category ID
14	ACCOMP_CATEGORY	Character(3)	VARCHAR2(3) NOT NULL	Accomplishment Category DEG=Degree HON=Honor or Award LIC=License or Certification LNG=Language MEM=Membership NVQ=NVQ TST=Test