ACTION_STAT_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ACTION	Character(3)	VARCHAR2(3) NOT NULL	Action Prompt Table: ACTION_TBL
2	SET_STATUS_FLG	Character(1)	VARCHAR2(1) NOT NULL	Action sets Status Fields Y/N Table Edit Default Value: N
3	EMPL_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Payroll Status A=Active D=Deceased L=Leave of Absence P=Leave With Pay Q=Retired With Pay R=Retired S=Suspended T=Terminated U=Terminated With Pay V=Terminated Pension Pay Out W=Short Work Break X=Retired-Pension Administration
4	HR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	HR Status A=Active I=Inactive
5	PEN_EMPL_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Employee Status X=Retired - Pension Administrati
6	PER_ORG_VALID	Character(1)	VARCHAR2(1) NOT NULL	Used to determine if a particular Action is valid in the JOB entry PER_ORG for the PER_ORG_ASGN row is this value. 0=EMP, CWR or POI 1=Employee Only 2=Contingent Worker only 3=Contingent Worker or POI 4=Person of Interest Only 5=Employee or Contingent Worker Default Value: 0
7	HR_STATUS_VALID	Character(1)	VARCHAR2(1) NOT NULL	Used to determine if a particular Action is valid in the JOB entry if the Previous HR Status (EFF_STATUS) is equal to this value. A=Active I=Inactive
8	EMPL_STATUS_VALID	Character(1)	VARCHAR2(1) NOT NULL	Used to determine if a particular Action is valid in the JOB entry if the Previous Pay Status (EMPL_STATUS) is equal to this value. 0=S - Suspended 1=W - Short Work Break 2=P/L - Any Leave 3=P/L - Disability Leave 4=Act, Leave, Sus, Ret, SWB 5=Act, Leave, Sus, Ret, SWB, TWP
9	MESSAGE_SET_NBR	Number(5,0)	INTEGER NOT NULL	Message Set Number. This field refers to the Message Set Number in the Message Catalog. Prompt Table: PSMSGSETDEFN
10	MESSAGE_NBR	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog. Prompt Table: PSMSGCATDEFN
11	SET_HIRE_DT	Character(1)	VARCHAR2(1) NOT NULL	Indicate whether the Action will set the PER_ORG_INST.HIRE_DT 0=No Action 2=JOB.EFFDT Default Value: 0
12	SET_LST_HIRE_DT	Character(1)	VARCHAR2(1) NOT NULL	Indicate whether the Action will set the PER_ORG_INST.LST_HIRE_DT 0=No Action 2=JOB.EFFDT Default Value: 0
13	SET_TERM_DT	Character(1)	VARCHAR2(1) NOT NULL	Indicate whether the Action will set the PER_ORG_INST_TERMINATON_DT 0=No Action 1=Clear 3=JOB.EFFDT - 1 Default Value: 0
14	SET_ASGN_ST_DT	Character(1)	VARCHAR2(1) NOT NULL	Indicate whether the Action will set the PER_ORG_INST_TERMINATON_DT 0=No Action 2=JOB.EFFDT Default Value: 0
15	SET_ASGN_LST_DT	Character(1)	VARCHAR2(1) NOT NULL	Indicate whether the Action will set the PER_ORG_ASGN.SET_LST_START_DT 0=No Action 2=JOB.EFFDT Default Value: 0
16	SET_ASGN_END_DT	Character(1)	VARCHAR2(1) NOT NULL	Indicate whether the Action will set the PER_ORG_ASGN.SET_ASGN_END_DT 0=No Action 1=Clear 3=JOB.EFFDT -1 Default Value: 0
17	SET_LDW	Character(1)	VARCHAR2(1) NOT NULL	Indicate whether the Action will set the JOB.LAST_DATE_WORKED 0=No Action 1=Clear 3=JOB.EFFDT - 1 Default Value: 0
18	SET_EXP_END_DT	Character(1)	VARCHAR2(1) NOT NULL	Indicate whether the Action will set the JOB_DATES.EXPECTED_END_DT 0=No Action 1=Clear Default Value: 0
19	SET_EXP_RTRN_DT	Character(1)	VARCHAR2(1) NOT NULL	Indicate whether the Action will set the JOB_DATES.EXPECTED_RETURN_DT 0=No Action 1=Clear Default Value: 0
20	OBJECTOWNERID	Character(4)	VARCHAR2(4) NOT NULL	Object owner identifier
21	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. Default Value: %datetime
22	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
23	SYSTEM_DATA_FLG	Character(1)	VARCHAR2(1) NOT NULL	This Y/ N field is used to identify which rows in a table are considered SYSTEM DATA. Y/N Table Edit Default Value: N