GPFR_AF_EE_LIST

(SQL Table)
Index Back

Employee List

Application Framework -

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
2 GPFR_AF_APPL Character(10) VARCHAR2(10) NOT NULL Application Framework - Application
3 GPFR_AF_EXTRACT_ID Character(18) VARCHAR2(18) NOT NULL Application Framework - Extraction ID
4 GPFR_AF_SNDREF Character(10) VARCHAR2(10) NOT NULL Application Framework - Sending Reference
5 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
6 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
7 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract Number

Default Value: 0

8 GPFR_AF_NODE_SET Character(16) VARCHAR2(16) NOT NULL Application Framework - Node Set
9 GPFR_AF_EXT_BGN_DT Date(10) DATE Application Framework - Extraction Begin Date
10 GPFR_AF_EXT_END_DT Date(10) DATE Application Framework - Extraction End Date
11 GPFR_AF_UF_01 Character(50) VARCHAR2(50) NOT NULL User Fields
12 GPFR_AF_UF_02 Character(50) VARCHAR2(50) NOT NULL User Fields
13 GPFR_AF_UF_03 Character(50) VARCHAR2(50) NOT NULL User Fields
14 GPFR_AF_UF_04 Character(50) VARCHAR2(50) NOT NULL User Fields
15 GPFR_AF_UF_05 Character(50) VARCHAR2(50) NOT NULL User Fields
16 GPFR_AF_UF_06 Character(50) VARCHAR2(50) NOT NULL User Fields
17 GPFR_AF_UF_07 Character(50) VARCHAR2(50) NOT NULL User Fields
18 GPFR_AF_UF_08 Character(50) VARCHAR2(50) NOT NULL User Fields
19 GPFR_AF_UF_09 Character(50) VARCHAR2(50) NOT NULL User Fields
20 GPFR_AF_UF_10 Character(50) VARCHAR2(50) NOT NULL User Fields