FPY_BNS_PSHUP_1

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	FPY_BNS_RUN_ID	Number(20,0)	DECIMAL(20) NOT NULL	Bonus Run ID
2	FPY_ELE_ENT_ID	Number(20,0)	DECIMAL(20) NOT NULL	Element Entity ID
3	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
4	FPY_PROC_MARKER	Character(36)	VARCHAR2(36) NOT NULL	FPY_PROC_MARKER
5	FPY_ERROR_FLAG	Character(1)	VARCHAR2(1) NOT NULL	FPY Error Flag N=No Y=Yes
6	FPY_MODE	Character(1)	VARCHAR2(1) NOT NULL	FPY_MODE
7	FPY_JOB_CI	Character(1)	VARCHAR2(1) NOT NULL	FPY_JOB_CI
8	FPY_PROCESSED_FLG	Character(1)	VARCHAR2(1) NOT NULL	Processed Flag
9	FPY_BYPASS_FLG	Character(1)	VARCHAR2(1) NOT NULL	Bypass Flag
10	FPY_ERR_CORR_REQD	Character(1)	VARCHAR2(1) NOT NULL	Correction Required N=No Y=Yes
11	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
12	CREATION_DT	Date(10)	DATE	Creation Date
13	EARNS_BEGIN_DT	Date(10)	DATE	Earnings Begin Date
14	EARNS_END_DT	Date(10)	DATE	Earnings End Date
15	FPY_ASG_ID	Number(18,0)	DECIMAL(18) NOT NULL	Assignment ID
16	FPY_PERSON_ID	Character(18)	VARCHAR2(18) NOT NULL	Person ID
17	FPY_ERNCD	Character(120)	VARCHAR2(120) NOT NULL	Earnings Code
18	FPY_ELE_ENT_VAL_ID	Number(20,0)	DECIMAL(20) NOT NULL	Element Entity Value ID
19	PU_TXN_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Paysheet transaction type. C=Canada Tax Override D=Deduction Override E=Earnings G=Total Gross N=Net Pay O=Override S=Garnishment Override T=US Tax Override