GPFR_DSN_SNDREF

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GPFR_DA_SNDREF	Character(10)	VARCHAR2(10) NOT NULL	DADS related field
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
3	GPFR_DSN_MNTLY_QLF	Character(1)	VARCHAR2(1) NOT NULL	Monthly DSN Y/N Table Edit
4	GPFR_DSN_EVENT_QLF	Character(1)	VARCHAR2(1) NOT NULL	Event DSN Y/N Table Edit
5	GPFR_DSN_FRCTN_NBR	Number(2,0)	SMALLINT NOT NULL	Fraction Number
6	GPFR_DA_TRANS	Character(10)	VARCHAR2(10) NOT NULL	DADS related field Prompt Table: GPFR_DA_ESTREP
7	GPFR_DA_ESTREP	Character(12)	VARCHAR2(12) NOT NULL	DADS related field. Prompt Table: ESTAB_TBL
8	GPFR_DSN_RCV_EMAIL	Character(70)	VARCHAR2(70) NOT NULL	Email of receiver
9	GPFR_DSN_FLTR_JOB	Character(1)	VARCHAR2(1) NOT NULL	Filter on JOB Y/N Table Edit Default Value: N
10	GPFR_DSN_FLTR_CNTR	Character(1)	VARCHAR2(1) NOT NULL	Filter on CONTRACT Y/N Table Edit Default Value: N
11	GPFR_DSN_SQLFILTER	Long Character	CLOB	Filter
12	GPFR_DSN_CHR_UF_01	Character(50)	VARCHAR2(50) NOT NULL	User Fields
13	GPFR_DSN_CHR_UF_02	Character(50)	VARCHAR2(50) NOT NULL	User Fields
14	GPFR_DSN_CHR_UF_03	Character(50)	VARCHAR2(50) NOT NULL	User Fields
15	GPFR_DSN_CHR_UF_04	Character(50)	VARCHAR2(50) NOT NULL	User Fields
16	GPFR_DSN_CHR_UF_05	Character(50)	VARCHAR2(50) NOT NULL	User Fields
17	GPFR_DSN_NBR_UF_01	Number(15,0)	DECIMAL(15) NOT NULL	User field 01
18	GPFR_DSN_NBR_UF_02	Number(15,0)	DECIMAL(15) NOT NULL	User field 02
19	GPFR_DSN_NBR_UF_03	Number(15,0)	DECIMAL(15) NOT NULL	User field 03
20	GPFR_DSN_NBR_UF_04	Number(15,0)	DECIMAL(15) NOT NULL	User field 04
21	GPFR_DSN_NBR_UF_05	Number(15,0)	DECIMAL(15) NOT NULL	User field 05
22	GPFR_DSN_DT_UF_01	Date(10)	DATE	Userfield 01
23	GPFR_DSN_DT_UF_02	Date(10)	DATE	Userfield 02
24	GPFR_DSN_DT_UF_03	Date(10)	DATE	Userfield 03
25	GPFR_DSN_DT_UF_04	Date(10)	DATE	Userfield 04
26	GPFR_DSN_DT_UF_05	Date(10)	DATE	Userfield 05