CC_HRSPLIT2_AET

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
4 CHAR_1 Character(1) VARCHAR2(1) NOT NULL Character
5 DT_TIMESTAMP DateTime(26) TIMESTAMP Date Timestamp
6 FILE_PATH Character(127) VARCHAR2(127) NOT NULL Input/Output file path
7 FILENAME Character(80) VARCHAR2(80) NOT NULL File Name
8 OBJECTID1 Number(5,0) INTEGER NOT NULL Object Id 1
1=Record
2=Field
3=Menu
4=Bar Name
5=Item Name
9=Page
10=Component
12=Event
20=Database Type
21=Effective Date
39=Market
60=Message
66=Application Engine Program
74=Component Interface
77=Section
78=Step
87=Subscription
104=Application Package
105=Class
106=Class
107=Class
9 OBJECTID2 Number(5,0) INTEGER NOT NULL Object Id 2, as OBJECTID1
10 OBJECTID3 Number(5,0) INTEGER NOT NULL Object Id 3, as OBJECTID1
11 OBJECTID4 Number(5,0) INTEGER NOT NULL Object Id 4, as OBJECTID1
12 OBJECTVALUE1 Character(100) VARCHAR2(100) NOT NULL Object Value 1
13 OBJECTVALUE2 Character(100) VARCHAR2(100) NOT NULL Object Value 2
14 OBJECTVALUE3 Character(30) VARCHAR2(30) NOT NULL Object Value 3
15 OBJECTVALUE4 Character(30) VARCHAR2(30) NOT NULL Object Value 4
16 PROJECTNAME Character(30) VARCHAR2(30) NOT NULL Project Name (see PSPROJECTDEFN).
17 PS_HOME Character(254) VARCHAR2(254) NOT NULL PS_HOME Directory
18 WHEREUSEDCHILDTYPE Signed Number(6,0) DECIMAL(5) NOT NULL Child Type
19 SCAN_LIST_OUT Number(9,0) DECIMAL(9) NOT NULL Scan List Output
20 WHEREUSEDPARENT Character(100) VARCHAR2(100) NOT NULL Parent
21 WHEREUSEDPARTYPE Signed Number(6,0) DECIMAL(5) NOT NULL Parent Type
22 RUN_PROJ_GEN Character(1) VARCHAR2(1) NOT NULL Run Project Generation