P 2 K_AM_SIGN_OFFS

Alias: MSO#

(P2K_AM_SIGN_OFFS)

Unique Keys:
Child Table:
Parent Table: P2K_AM_IMPORTANT_INFORMATION
ERD:


P2K_AM_SIGN_OFFS

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
MII_IDNumber(10)IDYlink to P2K_AM_IMPORTANT_INFORMATION
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
EEM_IDNumber(10)ID link to P2K_HR_EMPLOYMENTS
RCA_IDNumber(10)ID link to P2K_RE_CANDIDATES
SIGNED_OFFVARCHAR2(1)TOGGLEN
SIGN_OFF_TIMESTAMPDATETIMEDATEN
HASH_CHECKRAWRAWN
COLUMN01VARCHAR2(4000)VARCHAR4000N
COLUMN02VARCHAR2(4000)VARCHAR4000N
COLUMN03VARCHAR2(4000)VARCHAR4000N
COLUMN04VARCHAR2(4000)VARCHAR4000N
COLUMN05VARCHAR2(4000)VARCHAR4000N

User Fields: Allowed
Audit Logging: Allowed



Notes #

Click to create a new notes page