HCR_OC2_ERR_WRN (SQL Table)	Index Back
Org Changes Load To Job errors and warnings Used by batch process Promote an assignment to an Instance

HCR_OC2_ERR_WRN

(SQL Table)

Org Changes

Load To Job errors and warnings Used by batch process Promote an assignment to an Instance

# 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: PERS_SRCH_GBL

4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

5 EFFDT Date(10) DATE Effective Date
Default Value: %date

6 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence

7 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.

8 ACTION Character(3) VARCHAR2(3) NOT NULL Action

9 ACTION_REASON Character(3) VARCHAR2(3) NOT NULL Reason Code

10 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number

11 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.

12 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.

13 MSG_SEVERITY Character(1) VARCHAR2(1) NOT NULL Message Severity
C=Cancel
E=Error
M=Message
W=Warning
Default Value: M

14 MESSAGE_TEXT Character(100) VARCHAR2(100) NOT NULL Message Text This field refers to the Text for a particular Message Number in the Message Catalog.

15 MESSAGE_TEXT_WRK Character(250) VARCHAR2(250) NOT NULL Message Text

16 DESCRLONG Long Character CLOB Long Description

#	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: PERS_SRCH_GBL
4	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
5	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
6	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
7	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.
8	ACTION	Character(3)	VARCHAR2(3) NOT NULL	Action
9	ACTION_REASON	Character(3)	VARCHAR2(3) NOT NULL	Reason Code
10	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
11	MESSAGE_SET_NBR	Number(5,0)	INTEGER NOT NULL	Message Set Number. This field refers to the Message Set Number in the Message Catalog.
12	MESSAGE_NBR	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog.
13	MSG_SEVERITY	Character(1)	VARCHAR2(1) NOT NULL	Message Severity C=Cancel E=Error M=Message W=Warning Default Value: M
14	MESSAGE_TEXT	Character(100)	VARCHAR2(100) NOT NULL	Message Text This field refers to the Text for a particular Message Number in the Message Catalog.
15	MESSAGE_TEXT_WRK	Character(250)	VARCHAR2(250) NOT NULL	Message Text
16	DESCRLONG	Long Character	CLOB	Long Description