GPFR_DSN_OPSTMP

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
3	GPFR_AF_APPL	Character(10)	VARCHAR2(10) NOT NULL	Application Framework - Application
4	GPFR_AF_EXTRACT_ID	Character(18)	VARCHAR2(18) NOT NULL	Application Framework - Extraction ID
5	GPFR_AF_SNDREF	Character(10)	VARCHAR2(10) NOT NULL	Application Framework - Sending Reference
6	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
7	OPS_TYPE_FRA	Character(10)	VARCHAR2(10) NOT NULL	OPSType (FRA)
8	PAYER_ESTAB_ID	Character(12)	VARCHAR2(12) NOT NULL	Payer Establishment
9	ESTABID	Character(12)	VARCHAR2(12) NOT NULL	Establishment ID
10	MEMBERSHIP_NBR_FRA	Character(20)	VARCHAR2(20) NOT NULL	Membership Number - France
11	FUND_INST_VAL_FRA	Character(20)	VARCHAR2(20) NOT NULL	Deligate instutiion ID
12	OPS_DLG_TYPE_FRA	Character(10)	VARCHAR2(10) NOT NULL	Delegate Code (FRA)
13	USE_CONTRACT_FRA	Character(1)	VARCHAR2(1) NOT NULL	Use Contract
14	FUND_DELG_VAL_FRA	Character(20)	VARCHAR2(20) NOT NULL	Deligate instutiion ID
15	REPORT_ON_RETRO	Character(1)	VARCHAR2(1) NOT NULL	Report on DSN?
16	CASE_CODE	Character(10)	VARCHAR2(10) NOT NULL	Case Code
17	MEMFEE_CONT_CODE	Character(10)	VARCHAR2(10) NOT NULL	Membership fee Contribution code
18	PAY_METHOD_FRA	Character(10)	VARCHAR2(10) NOT NULL	Payment Method
19	DEP_SCHED_ID_FRA	Character(10)	VARCHAR2(10) NOT NULL	Deposit Schedule
20	PRD_BGN_DT	Date(10)	DATE	Period Begin Date
21	PRD_END_DT	Date(10)	DATE	Pay Period End Date
22	DAY_UOM	Character(1)	VARCHAR2(1) NOT NULL	Unit of Time in various increments of days (day being the lowest unit of measure). Used for schedule generation D=Day M=Month Q=Quarter W=Week Y=Year
23	SOURCE_BANK_ID_FRA	Character(10)	VARCHAR2(10) NOT NULL	Source Bank Id