!!!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]| | 

!![Derived Fields|DERIVED FIELDS]
||Column Name
|[DRV_COLUMN_PROMPT]
|[DRV_NEW_VALUE]
|[DRV_OLD_VALUE]
|[DRV_SORT_ORDER_CLMN]
|[DRV_TABLE_ALIAS]


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


----
![Notes|Edit:Internal.P2K_SA_PERSONNEL_CHANGES] 	
[{InsertPage page='Internal.P2K_SA_PERSONNEL_CHANGES' default='Click to create a new notes page'}]