PAY_EXCEPTIONS

Details

Schema: FUSION
Object owner: PAY
Object type: TABLE
Tablespace: FUSION_TS_TX_DATA

Primary Key

Name	Columns
PAY_EXCEPTIONS_PK	PAYROLL_EXCEPTION_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
PAYROLL_EXCEPTION_ID	NUMBER		18	Yes	Primary Key
SOURCE	VARCHAR2	32			Source of the exception
PERSON_ID	NUMBER		18		Person identifier
PAYROLL_RELATIONSHIP_ID	NUMBER		18		Payroll Relationship identifier
HR_ASSIGNMENT_ID	NUMBER		18		HR Assignment identifier
PROCESS_IDENTIFIER	NUMBER		18		Process identifier
TIME_PERIOD_ID	NUMBER		18		Period identifier
EXCEPTION_TYPE	VARCHAR2	32			Exception type
EXCEPTION_CODE	VARCHAR2	128			Exception code
EXCEPTION_DETAIL	VARCHAR2	4000			Exception detail
EXCEPTION_OBJECT_ID	NUMBER		18		Object which is this exceptions context
AI_VERDICT	VARCHAR2	32			AI verdict
AI_EXPLANATION	VARCHAR2	4000			AI explanation
AI_CONFIDENCE_LEVEL	NUMBER		5		AI confidence level
HUMAN_VERDICT	VARCHAR2	32			Human verdict
HUMAN_EXPLANATION	VARCHAR2	4000			Human explanation
ASSIGNED_TO	VARCHAR2	64			Assigned to
STATUS	VARCHAR2	20			Status
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
ENTERPRISE_ID	NUMBER		18	Yes	Enterprise ID
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.

Indexes

Index	Uniqueness	Tablespace	Columns
PAY_EXCEPTIONS_PK	Unique	Default	PAYROLL_EXCEPTION_ID