FPY_ERR_IDEN_VW

(SQL View)
Index Back

Error Identifier View

Error Identifier View

SELECT FPY_BO_TYPE ,FPY_BUS_OBJ ,FPY_ERROR_CODE ,FPY_ERR_SUBCAT ,FPY_ERROR_TYPE , FPY_IDENTIFIER FROM PS_FPY_ERROR_LOG

# 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_SUBCAT Character(4) VARCHAR2(4) NOT NULL Sub Category
BLVL=Blank Values
CIER=Component Interface Error
5 FPY_ERROR_TYPE Character(1) VARCHAR2(1) NOT NULL FPY Error Type
D=Dependent Errors
E=Errors Requiring Action
W=Warning
6 FPY_IDENTIFIER Character(254) VARCHAR2(254) NOT NULL Fusion Identifier