!!!Alias: SPC
(P2K_SA_PERSONNEL_CHANGES)

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

!!Table Columns
\\
||Column name||Data Type / Size||Domain||Mand.||Notes 
|[ID]|Number(10)|[ID]|Y| 
|[SPA_ID]|Number(10)|[ID]|Y|link to [P2K_SA_PERSONNEL_ACTIONS]
|[SPYC_ID]|Number(10)|[ID]|Y|link to [P2K_SA_PA_TYPE_COLUMNS]
|[PA_CHANGE_STATUS]|Varchar2(2)|[X_PA_CHANGE_STATUS]|Y| 
|[CREATE_DATE]|Date()|[DATE]|Y| 
|[CREATE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y| 
|[CHANGE_DATE]|Date()|[DATE]|Y| 
|[CHANGE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y| 
|[PA_TYPE_OF_VALUE]|Varchar2(2)|[X_PA_TYPE_OF_VALUE]|Y| 
|[REFERENCE_ID]|Number(10)|[NUMBER10|NUMBERn]| | 
|[COLUMN_SEQUENCE]|Number(5)|[NUMBER5|NUMBERn]| | 
|[PA_OLD_VALUE]|Varchar2(2000)|[VARCHAR2000|VARCHARnn]| | 
|[PA_NEW_VALUE]|Varchar2(2000)|[VARCHAR2000|VARCHARnn]| | 

User Fields: Not Allowed\\
Audit Logging: Allowed\\