RTBL_OPR_HIS_EM

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EOAWREQUESTOR_ID	Character(30)	VARCHAR2(30) NOT NULL	Requestor id
2	SCE_ID	Character(10)	VARCHAR2(10) NOT NULL	ID
3	RTBL_SCENARIO	Character(18)	VARCHAR2(18) NOT NULL	Scenario Name
4	SCE_CREATE_DTTM	DateTime(26)	TIMESTAMP	Create Datetime
5	SCE_DEPLOY_REQ_ID	Number(15,0)	DECIMAL(15) NOT NULL	Request ID
6	SEQNBR	Number(5,0)	INTEGER NOT NULL	Sequence Number Default Value: 0
7	RTBL_ELEMENT	Character(30)	VARCHAR2(30) NOT NULL	Element name to identify (in peoplesoft) an element along with its label.
8	VERSION_NUM	Number(3,0)	SMALLINT NOT NULL	Version Number
9	LEVEL1	Number(5,0)	INTEGER NOT NULL	Level 1
10	LEVEL2	Number(5,0)	INTEGER NOT NULL	Level 2
11	LEVEL3	Number(5,0)	INTEGER NOT NULL	Level 3
12	CLOSING_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Closing Type I=Interim Y=Year End
13	SELECT_CB	Character(1)	VARCHAR2(1) NOT NULL	Select Check Box N=No Y=Yes Y/N Table Edit
14	LEVEL_NUM	Number(3,0)	SMALLINT NOT NULL	Level
15	ROW_NUMBER_5	Number(5,0)	INTEGER NOT NULL	Row Number
16	RTBL_ELEMENT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Element name to identify (in peoplesoft) an element along with its label. A=Allocation C=Close Ledgers J=Journal M=Multi-currency U=User Defined
17	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
18	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
19	RTBL_CHECKPOINT	Character(1)	VARCHAR2(1) NOT NULL	Checkpoint Y/N Table Edit
20	CONTINUE_WITH_GRP	Character(1)	VARCHAR2(1) NOT NULL	Continue Processing the Group Y/N Table Edit
21	STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status Indicator A=Active I=Inactive
22	EXCLUDE	Character(1)	VARCHAR2(1) NOT NULL	Exclude N=No Y=Yes
23	ASOFDATE	Date(10)	DATE	As of Date
24	EFFECTIVE_DATE	Date(10)	DATE	Effective Date
25	PRODUCTION_NAME	Character(30)	VARCHAR2(30) NOT NULL	Production Name