FT_ERR_RUN_CNTL

(SQL Table)
Index Back

Transformation Error Reporting

Record used with Transformation Error Reporting page

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

Prompt Table: FT_RPT_DERVIED1

4 FT_INTEGRATE_TYPE Character(1) VARCHAR2(1) NOT NULL Integration Type
I=Inbound
O=Outbound

Default Value: O

5 FT_ERROR_TYPE Character(4) VARCHAR2(4) NOT NULL Error types for fusion extract
BOBJ=Entire object bypassed
DMAP=Unable to load DVM map
DUPN=Duplicate Content Item Name
DVM=Unable to map the DVM value(s)
FOBJ=Object not supported by Fusion
MJOB=Employee with multiple jobs
MOBJ=Missing reference object
MSAL=Multiple Salary Bases
NTER=Termination row updates
OOBJ=Other Objects Bypassed
PNOV=Position override
POBJ=Object Bypassed By Parent
ROBJ=Reference to object in error
XMAP=Unable to load XREF map
XREF=Unable to map the XREF

Prompt Table: FT_RPT_DERVIED
Set Control Field: FT_ERROR_TYPE

6 FT_ERR_RPT_TYPE Character(1) VARCHAR2(1) NOT NULL FT Error Report Type
D=Detail
S=Summary

Default Value: S

7 FT_ERR_FLTR_BY Character(1) VARCHAR2(1) NOT NULL Error Report Filter By
B=Business Unit
D=Department
L=Location

Default Value: B