HCR_OC_ASG_TMP

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: HCR_OC_PRO_VW1
4	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr Prompt Table: HCR_OC_PRO_VW
5	ORG_INSTANCE_ERN	Number(3,0)	SMALLINT NOT NULL	Indicates which EMPL_RCD (ERN) is considered the Organizational Instance for this particular ERN. An Organizational Instance defines an Instance of Employment or an Instance of Contingent Workforce. Hire, Termination, and Service dates are captured at the Organiational Instance level.
6	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
7	OLD_ORG_INSTANCE	Number(3,0)	SMALLINT NOT NULL	Indicates which EMPL_RCD (ERN) is considered the Organizational Instance for this particular ERN. An Organizational Instance defines an Instance of Employment or an Instance of Contingent Workforce. Hire, Termination, and Service dates are captured at the Organiational Instance level.
8	ACTION	Character(3)	VARCHAR2(3) NOT NULL	Action
9	ACTION_REASON	Character(3)	VARCHAR2(3) NOT NULL	Reason Code Prompt Table: ACTN_REASON_TBL
10	HCR_OC_EXEC_ST_FLG	Character(1)	VARCHAR2(1) NOT NULL	Organization Changes - Promote an assignment to an instance Execution status flag C=Cancel F=Failure R=Ready S=Success Default Value: R
11	HCR_OC_EXEC_FLG	Character(1)	VARCHAR2(1) NOT NULL	Organization Changes - Promote an assignment to an instance Execute flag Y/N Table Edit