Alias: SPC#

(P2K_SA_PERSONNEL_CHANGES)

Unique Keys:
Child Table:
Parent Table:
ERD; ERD-SA05
Personnel Changes

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
SPA_IDNumber(10)IDYlink to P2K_SA_PERSONNEL_ACTIONS
SPYC_IDNumber(10)IDYlink to P2K_SA_PA_TYPE_COLUMNS
PA_CHANGE_STATUSVarchar2(2)X_PA_CHANGE_STATUSY
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
PA_TYPE_OF_VALUEVarchar2(2)X_PA_TYPE_OF_VALUEY
REFERENCE_IDNumber(10)NUMBER10
COLUMN_SEQUENCENumber(5)NUMBER5
PA_OLD_VALUEVarchar2(2000)VARCHAR2000
PA_NEW_VALUEVarchar2(2000)VARCHAR2000

User Fields: Not Allowed
Audit Logging: Allowed