FPY_ERROR_LOG

(SQL Table)
 Index Back

Error Log

Error Log

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 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
3 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
4 FPY_PROC_MARKER Character(36) VARCHAR2(36) NOT NULL FPY_PROC_MARKER
5 FPY_MAP_NAME Character(150) VARCHAR2(150) NOT NULL FPY_MAP_NAME
6 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
7 FPY_KEY_STR1_VAL Character(120) VARCHAR2(120) NOT NULL Key String Value 1
8 FPY_KEY_STR2_VAL Character(120) VARCHAR2(120) NOT NULL Key String Value2
9 FPY_KEY_STR3_VAL Character(120) VARCHAR2(120) NOT NULL Key String value 3
10 FPY_KEY_STR4_VAL Character(120) VARCHAR2(120) NOT NULL Key String Value4
11 FPY_KEY_NUM1_VAL Number(20,0) DECIMAL(20) NOT NULL Key number 1 Value
12 FPY_KEY_NUM2_VAL Number(20,0) DECIMAL(20) NOT NULL Key Number Value 2
13 FPY_KEY_DT1_VAL Date(10) DATE Key Date Value1
14 FPY_KEY_STR1_FLD Character(20) VARCHAR2(20) NOT NULL Key String Field1
15 FPY_KEY_STR2_FLD Character(20) VARCHAR2(20) NOT NULL Key String Field2
16 FPY_KEY_STR3_FLD Character(20) VARCHAR2(20) NOT NULL Key String Field3
17 FPY_KEY_STR4_FLD Character(20) VARCHAR2(20) NOT NULL Key Field String 4
18 FPY_KEY_NUM1_FLD Character(20) VARCHAR2(20) NOT NULL Key Nummer Field 1
19 FPY_KEY_NUM2_FLD Character(20) VARCHAR2(20) NOT NULL Key Field Number 2
20 FPY_KEY_NUM3_FLD Character(20) VARCHAR2(20) NOT NULL Key Number Field
21 FPY_KEY_NUM3_VAL Number(3,0) SMALLINT NOT NULL Key Number Value
22 FPY_KEY_DT1_FLD Character(20) VARCHAR2(20) NOT NULL Key Date Field 1
23 FPY_ERR_SUBCAT Character(4) VARCHAR2(4) NOT NULL Sub Category
BLVL=Blank Values
CIER=Component Interface Error
24 FPY_ERROR_TYPE Character(1) VARCHAR2(1) NOT NULL FPY Error Type
D=Dependent Errors
E=Errors Requiring Action
W=Warning
25 FPY_ERR_CORR_REQD Character(1) VARCHAR2(1) NOT NULL Correction Required
N=No
Y=Yes

Default Value: Y

26 FPY_IDENT_SOURCE Character(3) VARCHAR2(3) NOT NULL Idnetifier Source
FUS=Fusion
PSF=Peoplesoft
27 FPY_IDENTIFIER Character(254) VARCHAR2(254) NOT NULL Fusion Identifier
28 FPY_PS_IDENTIFIER Character(120) VARCHAR2(120) NOT NULL Peoplesoft Identifier
29 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
30 FPY_DESCR Long Character CLOB Description
31 FPY_RECNAME_TRANS Character(15) VARCHAR2(15) NOT NULL FPY_RECNAME_TRANS
32 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
33 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
34 RUN_DTTM DateTime(26) TIMESTAMP Run Date and Time