GPFR_DSN_CIESTB

(SQL Table)
Index Back

DSN-View extraction results

Application Framework - DSN -This is the company establishment guide 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 GPFR_AF_SND_LVL2 Character(20) VARCHAR2(20) NOT NULL Sending Level
10 GPFR_DUCS_CD Character(10) VARCHAR2(10) NOT NULL GPFR: DUCS Code
11 GPFR_AF_EXT_BGN_DT Date(10) DATE Application Framework - Extraction Begin Date
12 GPFR_AF_EXT_END_DT Date(10) DATE Application Framework - Extraction End Date
13 GPFR_AF_UF_01 Character(50) VARCHAR2(50) NOT NULL User Fields
14 GPFR_AF_UF_02 Character(50) VARCHAR2(50) NOT NULL User Fields
15 GPFR_AF_UF_03 Character(50) VARCHAR2(50) NOT NULL User Fields
16 GPFR_AF_UF_04 Character(50) VARCHAR2(50) NOT NULL User Fields
17 GPFR_AF_UF_05 Character(50) VARCHAR2(50) NOT NULL User Fields
18 GPFR_AF_UF_06 Character(50) VARCHAR2(50) NOT NULL User Fields
19 GPFR_AF_UF_07 Character(50) VARCHAR2(50) NOT NULL User Fields
20 GPFR_AF_UF_08 Character(50) VARCHAR2(50) NOT NULL User Fields
21 GPFR_AF_UF_09 Character(50) VARCHAR2(50) NOT NULL User Fields
22 GPFR_AF_UF_10 Character(50) VARCHAR2(50) NOT NULL User Fields
23 GPFR_DSN_IND_FIN Character(1) VARCHAR2(1) NOT NULL Sending reference extraction finalized

Y/N Table Edit

Default Value: N

24 CREATED_DTTM DateTime(26) TIMESTAMP Created Datetime