FPY_REPORT_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	FPY_BO_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Business Object Type A=All B=Bonus C=Company D=Department E=Absence J=Job Data L=Location O=Job Code P=Person Details S=Position Data U=Business Unit
2	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
3	FPY_ERROR_CODE	Character(4)	VARCHAR2(4) NOT NULL	FPY Error Code CIER=CI Errors COBJ=Child Object Bypassed DVME=DVM Errors EOBJ=Entire Object Bypassed FABS=Future Dated Absence Entry FUSE=Fusion Errors INVD=Unexpected Exception MOBJ=Missing Objects Bypassed PNAE=PNA Error POBJ=Parent Objects Bypassed ROBJ=Referenced Object Bypassed
4	FPY_ERR_ACT_REQD	Character(1)	VARCHAR2(1) NOT NULL	Action required E=Errors Requiring Action X=No Action reqd
5	FPY_DEP_ERROR	Character(1)	VARCHAR2(1) NOT NULL	Dependent Error D=Dependent Errors X=No
6	FPY_WARNING	Character(1)	VARCHAR2(1) NOT NULL	Warning W=Warnings X=no
7	FPY_ERROR_DISPLAY	Character(1)	VARCHAR2(1) NOT NULL	FPY Data in Error E=Errors N=New Objects
8	FPY_PROCESSED_DISP	Character(1)	VARCHAR2(1) NOT NULL	Data processed N=No Y=Yes
9	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance