FPY_ERR_DT_VW

(SQL View)
 Index Back

Error Details View

Error Details View

SELECT FPY_BO_TYPE , (CASE FPY_BUS_OBJ WHEN 'JCI' THEN 'JOB' WHEN 'PCI' THEN 'PER' WHEN 'SCI' THEN 'POS' WHEN 'CCI' THEN 'CMP' WHEN 'LCI' THEN 'LOC' WHEN 'DCI' THEN 'DEP' WHEN 'OCI' THEN 'JCD' ELSE FPY_BUS_OBJ END) ,FPY_ERROR_CODE ,FPY_IDENTIFIER ,FPY_PS_IDENTIFIER ,FPY_KEY_STR1_VAL ,FPY_KEY_STR2_VAL ,FPY_KEY_STR3_VAL ,FPY_KEY_STR4_VAL ,FPY_KEY_NUM1_VAL ,FPY_KEY_NUM2_VAL ,FPY_KEY_NUM3_VAL ,FPY_KEY_DT1_VAL ,FPY_KEY_STR1_FLD ,FPY_KEY_STR2_FLD ,FPY_KEY_STR3_FLD ,FPY_KEY_STR4_FLD , FPY_KEY_NUM1_FLD ,FPY_KEY_NUM2_FLD ,FPY_KEY_NUM3_FLD ,FPY_KEY_DT1_FLD ,FPY_ERROR_TYPE ,FPY_MAP_NAME , FPY_DESCR ,1 ,FPY_ERR_CORR_REQD ,PROCESS_INSTANCE 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_IDENTIFIER Character(254) VARCHAR2(254) NOT NULL Fusion Identifier
5 FPY_PS_IDENTIFIER Character(120) VARCHAR2(120) NOT NULL Peoplesoft Identifier
6 FPY_KEY_STR1_VAL Character(120) VARCHAR2(120) NOT NULL Key String Value 1
7 FPY_KEY_STR2_VAL Character(120) VARCHAR2(120) NOT NULL Key String Value2
8 FPY_KEY_STR3_VAL Character(120) VARCHAR2(120) NOT NULL Key String value 3
9 FPY_KEY_STR4_VAL Character(120) VARCHAR2(120) NOT NULL Key String Value4
10 FPY_KEY_NUM1_VAL Number(20,0) DECIMAL(20) NOT NULL Key number 1 Value
11 FPY_KEY_NUM2_VAL Number(20,0) DECIMAL(20) NOT NULL Key Number Value 2
12 FPY_KEY_DT1_VAL Date(10) DATE Key Date Value1
13 FPY_KEY_STR1_FLD Character(20) VARCHAR2(20) NOT NULL Key String Field1
14 FPY_KEY_STR2_FLD Character(20) VARCHAR2(20) NOT NULL Key String Field2
15 FPY_KEY_STR3_FLD Character(20) VARCHAR2(20) NOT NULL Key String Field3
16 FPY_KEY_STR4_FLD Character(20) VARCHAR2(20) NOT NULL Key Field String 4
17 FPY_KEY_NUM1_FLD Character(20) VARCHAR2(20) NOT NULL Key Nummer Field 1
18 FPY_KEY_NUM2_FLD Character(20) VARCHAR2(20) NOT NULL Key Field Number 2
19 FPY_KEY_NUM3_FLD Character(20) VARCHAR2(20) NOT NULL Key Number Field
20 FPY_KEY_NUM3_VAL Number(3,0) SMALLINT NOT NULL Key Number Value
21 FPY_KEY_DT1_FLD Character(20) VARCHAR2(20) NOT NULL Key Date Field 1
22 FPY_ERROR_TYPE Character(1) VARCHAR2(1) NOT NULL FPY Error Type
D=Dependent Errors
E=Errors Requiring Action
W=Warning
23 FPY_MAP_NAME Character(150) VARCHAR2(150) NOT NULL FPY_MAP_NAME
24 FPY_DESCR Long Character CLOB Description
25 COUNT_ROWS Number(3,0) SMALLINT NOT NULL Count rows.
26 FPY_ERR_CORR_REQD Character(1) VARCHAR2(1) NOT NULL Correction Required
N=No
Y=Yes
27 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance