FPY_ERR_RPT_VW (SQL View)	Index Back
Error Summary Report View Error Summary Report View

FPY_ERR_RPT_VW

(SQL View)

Error Summary Report View

SELECT A.FPY_BO_TYPE ,(CASE A.FPY_BUS_OBJ WHEN 'JCI' THEN 'JOB' WHEN 'PCI' THEN 'PER' WHEN 'SCI' THEN 'POS' WHEN 'OCI' THEN 'JCD' WHEN 'DCI' THEN 'DEP' WHEN 'LCI' THEN 'LOC' WHEN 'CCI' THEN 'CMP' ELSE A.FPY_BUS_OBJ END) ,A.FPY_ERROR_CODE ,B.XLATLONGNAME ,0 ,A.RUN_DTTM ,A.PROCESS_INSTANCE FROM PS_FPY_ERROR_LOG A , PSXLATITEM B WHERE B.EFFDT = ( SELECT MAX(B_ED.EFFDT) FROM PSXLATITEM B_ED WHERE B.FIELDNAME = B_ED.FIELDNAME AND B.FIELDVALUE = B_ED.FIELDVALUE AND B_ED.EFFDT <= %CurrentDateIn) AND B.FIELDNAME = 'FPY_ERROR_CODE' AND B.FIELDVALUE=A.FPY_ERROR_CODE

# 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 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name

5 FPY_COUNT Number(2,0) SMALLINT NOT NULL Number of Parallel Process

6 FPY_EXECDTTM DateTime(26) TIMESTAMP Last Run Datetime

7 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

#	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	XLATLONGNAME	Character(30)	VARCHAR2(30) NOT NULL	Translate Long Name
5	FPY_COUNT	Number(2,0)	SMALLINT NOT NULL	Number of Parallel Process
6	FPY_EXECDTTM	DateTime(26)	TIMESTAMP	Last Run Datetime
7	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance