RTBL_SCEBU_VW

(SQL View)
 Index Back

SELECT A.SCE_ID , A.BUSINESS_UNIT , B.SEQNBR , B.RTBL_ELEMENT , B.VERSION_NUM , A.PROCESS , B.EXCLUDE , B.RTBL_CHECKPOINT , B.RTBL_ELEMENT_TYPE FROM PS_RTBL_BU A , PS_RTBL_ELEMENT B WHERE A.SCE_ID = B.SCE_ID AND A.PROCESS = 'Y' AND A.EXCLUDE = 'N'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SCE_ID Character(10) VARCHAR2(10) NOT NULL ID
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 SEQNBR Number(5,0) INTEGER NOT NULL Sequence Number
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 PROCESS Character(1) VARCHAR2(1) NOT NULL Process
N=No
Y=Yes
7 EXCLUDE Character(1) VARCHAR2(1) NOT NULL Exclude
N=No
Y=Yes

Y/N Table Edit

8 RTBL_CHECKPOINT Character(1) VARCHAR2(1) NOT NULL Checkpoint
9 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