RTBL_DEPLOY_HIS

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