FPY_BU_STG_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	FPY_BUSINESS_UNIT	Character(120)	VARCHAR2(120) NOT NULL	Business Unit Name
2	FPY_SETID	Character(50)	VARCHAR2(50) NOT NULL	Setid
3	FPY_START_DTTM	Character(50)	VARCHAR2(50) NOT NULL	Start Date Time
4	FPY_EFF_END_DT	Character(50)	VARCHAR2(50) NOT NULL	Effective End Date
5	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
6	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
7	FPY_PROC_MARKER	Character(36)	VARCHAR2(36) NOT NULL	FPY_PROC_MARKER
8	FPY_ERROR_FLAG	Character(1)	VARCHAR2(1) NOT NULL	FPY Error Flag N=No Y=Yes
9	FPY_MODE	Character(1)	VARCHAR2(1) NOT NULL	FPY_MODE
10	FPY_JOB_CI	Character(1)	VARCHAR2(1) NOT NULL	FPY_JOB_CI
11	FPY_PROCESSED_FLG	Character(1)	VARCHAR2(1) NOT NULL	Processed Flag
12	FPY_BYPASS_FLG	Character(1)	VARCHAR2(1) NOT NULL	Bypass Flag
13	FPY_ERR_CORR_REQD	Character(1)	VARCHAR2(1) NOT NULL	Correction Required N=No Y=Yes
14	FPY_BUS_OBJ	Character(3)	VARCHAR2(3) NOT NULL	Business Object ABS=Absence ADD=Person Address ALL=All BNS=Bonus BUS=Business Unit CCI=Company CMP=Compensation Data COM=Company DCI=Department DEP=Department EML=Person Email JCD=JobCode JCI=Job Data JOB=Job Data LCI=Location LEG=Person Legislative Data LOC=Location NAM=Person Name NID=Person National Identifier OCI=JobCode ORG=Organisation Instance PCI=Person PER=Person PHN=Person Phone POS=Position SCI=Position
15	FPY_LEGALENTITY_ID	Number(18,0)	DECIMAL(18) NOT NULL	Field to hold the value of Company coming from Fusion.
16	FPY_ANNUAL_FACTOR	Character(50)	VARCHAR2(50) NOT NULL	Annual Factor
17	FPY_DESCR	Long Character	CLOB	Description
18	FPY_EFF_STATUS	Character(120)	VARCHAR2(120) NOT NULL	Active Status
19	FPY_CURRENCY_CD	Character(60)	VARCHAR2(60) NOT NULL	Currency Code
20	FPY_COUNTRY	Character(240)	VARCHAR2(240) NOT NULL	Country
21	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
22	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
23	MIN_STD_HRS	Number(7,2)	DECIMAL(6,2) NOT NULL	Minimum Standard Hours
24	MAX_STD_HRS	Number(7,2)	DECIMAL(6,2) NOT NULL	Maximum Standard Hours
25	DESCR254A	Character(254)	VARCHAR2(254) NOT NULL	Long Description
26	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
27	STD_HOURS	Number(7,2)	DECIMAL(6,2) NOT NULL	Standard Hours
28	STD_HRS_FREQUENCY	Character(5)	VARCHAR2(5) NOT NULL	Standard Work Period
29	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
30	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
31	ACTIVE_INACTIVE	Character(1)	VARCHAR2(1) NOT NULL	Definition Active or Inactive? A=Active I=Inactive
32	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
33	DEFAULT_SETID	Character(5)	VARCHAR2(5) NOT NULL	Default Set ID