GPFR_DSN_EE_LST

(SQL Table)
Index Back

Employee List

Application Framework : DSN Employee List record

# 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 GPFR_AF_NODE_SET Character(16) VARCHAR2(16) NOT NULL Application Framework - Node Set
6 GPFR_DSN_TYPE Character(2) VARCHAR2(2) NOT NULL DSN Type
7 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
8 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID
9 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
10 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
11 GPFR_AF_SND_LVL2 Character(20) VARCHAR2(20) NOT NULL Sending Level
12 GPFR_AF_EXT_BGN_DT Date(10) DATE Application Framework - Extraction Begin Date
13 GPFR_AF_EXT_END_DT Date(10) DATE Application Framework - Extraction End Date
14 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract Number

Default Value: 0

15 GPFR_AF_UF_01 Character(50) VARCHAR2(50) NOT NULL User Fields
16 GPFR_AF_UF_02 Character(50) VARCHAR2(50) NOT NULL User Fields
17 GPFR_AF_UF_03 Character(50) VARCHAR2(50) NOT NULL User Fields
18 GPFR_AF_UF_04 Character(50) VARCHAR2(50) NOT NULL User Fields
19 GPFR_AF_UF_05 Character(50) VARCHAR2(50) NOT NULL User Fields
20 GPFR_AF_UF_06 Character(50) VARCHAR2(50) NOT NULL User Fields
21 GPFR_AF_UF_07 Character(50) VARCHAR2(50) NOT NULL User Fields
22 GPFR_AF_UF_08 Character(50) VARCHAR2(50) NOT NULL User Fields
23 GPFR_AF_UF_09 Character(50) VARCHAR2(50) NOT NULL User Fields
24 GPFR_AF_UF_10 Character(50) VARCHAR2(50) NOT NULL User Fields
25 GPFR_DSN_IND_FIN Character(1) VARCHAR2(1) NOT NULL Sending reference extraction finalized

Y/N Table Edit

Default Value: N

26 CREATED_DTTM DateTime(26) TIMESTAMP Created Datetime