RTBL_DEPLOYM_H

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