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

Derived Fields#

Column Name
DRV_COLUMN_PROMPT
DRV_NEW_VALUE
DRV_OLD_VALUE
DRV_SORT_ORDER_CLMN
DRV_TABLE_ALIAS

User Fields: Allowed
Audit Logging: Not Allowed


Notes #

Click to create a new notes page