Alias: SPA#

(P2K_SA_PERSONNEL_ACTIONS)

Unique Keys:
Child Table:
Parent Table:
ERD: ERD-SA05

Personnel Actions

Table Columns#

Column name	Data Type / Size	Domain	Mand.	Notes
ID	Number(10)	ID	Y
DEN_ID	Number(10)	ID	Y	link to P2K_CM_ENTITIES
PA_NUMBER	Number(10)	NUMBER10	Y
SPY_ID	Number(10)	ID	Y	link to P2K_SA_PA_TYPES
DCR_ID	Number(10)	ID		link to P2K_CM_CHANGE_REASONS
EEM_ID	Number(10)	ID	Y	link to P2K_HR_EMPLOYMENTS
SRV_ID	Number(10)	ID		link to P2K_SA_REVIEWS
EAS_ID	Number(10)	ID		link to P2K_HR_ASSIGNMENTS
MEX_ID_ORIGINATED	Number(10)	ID		link to P2K_AM_EXECUTIONS
MEX_ID_PROCESSED	Number(10)	ID		link to P2K_AM_EXECUTIONS
PA_STATUS	Varchar2(2)	X_PA_STATUS	Y
PA_EFFECTIVE_DATE	Date()	DATE	Y
PA_EXPIRY_DATE	Date()	DATE
APPROVED	Varchar2(1)	TOGGLE
DESCRIPTION	Varchar2(50)	DESCRIPTION
UPDATE_FUTURE_RECORDS	Varchar2(1)	TOGGLE
CASCADE_CHANGE_REASON	Varchar2(1)	TOGGLE
CREATE_DATE	Date()	DATE	Y
CREATE_USER	Varchar2(30)	VARCHAR30	Y
CHANGE_DATE	Date()	DATE	Y
CHANGE_USER	Varchar2(30)	VARCHAR30	Y
SPA_ID	Number(10)	ID		link to P2K_SA_PERSONNEL_ACTIONS
EFFECTIVE_DATE_CORRECTION	Varchar2(1)	TOGGLE
PA_EXPIRY_DATE	Date()	DATE
COMMENTS	VARCHAR2(4000)	VARCHAR4000
MSA_ID	Number(10)	ID		link to P2K_AM_SESSION_AUDITS

Derived Fields#

Column Name
DRV_APPROVAL_BAR
DRV_APPROVAL_COMMENTS
DRV_NEW_EFFECTIVE
DRV_ORIGINATED_BY
DRV_PROCESSED_BY

User Fields: Allowed
Audit Logging: Not Allowed

---

Notes #

Click to create a new notes page