P 2 K_SA_PERSONNEL_ACTIONS

Alias: SPA#

(P2K_SA_PERSONNEL_ACTIONS)

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


Personnel Actions

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
DEN_IDNumber(10)IDYlink to P2K_CM_ENTITIES
PA_NUMBERNumber(10)NUMBER10Y
SPY_IDNumber(10)IDYlink to P2K_SA_PA_TYPES
DCR_IDNumber(10)ID link to P2K_CM_CHANGE_REASONS
EEM_IDNumber(10)IDYlink to P2K_HR_EMPLOYMENTS
SRV_IDNumber(10)ID link to P2K_SA_REVIEWS
EAS_IDNumber(10)ID link to P2K_HR_ASSIGNMENTS
MEX_ID_ORIGINATEDNumber(10)ID link to P2K_AM_EXECUTIONS
MEX_ID_PROCESSEDNumber(10)ID link to P2K_AM_EXECUTIONS
PA_STATUSVarchar2(2)X_PA_STATUSY
PA_EFFECTIVE_DATEDate()DATEY
PA_EXPIRY_DATEDate()DATE
APPROVEDVarchar2(1)TOGGLE
DESCRIPTIONVarchar2(50)DESCRIPTION
UPDATE_FUTURE_RECORDSVarchar2(1)TOGGLE
CASCADE_CHANGE_REASONVarchar2(1)TOGGLE
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
SPA_IDNumber(10)ID link to P2K_SA_PERSONNEL_ACTIONS
EFFECTIVE_DATE_CORRECTIONVarchar2(1)TOGGLE
PA_EXPIRY_DATEDate()DATE
COMMENTSVARCHAR2(4000) VARCHAR4000
MSA_IDNumber(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

Screen captures are meant to be indicative of the concept being presented and may not reflect the current screen design.
If you have any comments or questions please email the Wiki Editor

All content © High Line Corporation