PTIASPPRJADSOBJ

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PTIASPPKGGUID Character(36) VARCHAR2(36) NOT NULL Unique Identifier
2 PROJECTNAME Character(30) VARCHAR2(30) NOT NULL Project Name (see PSPROJECTDEFN).
3 PTIASPADSNAME Character(30) VARCHAR2(30) NOT NULL Data Set Name
4 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
5 PTIASPKEYHASH Character(36) VARCHAR2(36) NOT NULL Hash of the key column values
6 PTKEYVALUE1 Character(150) VARCHAR2(150) NOT NULL Object Value 1
7 PTKEYVALUE2 Character(150) VARCHAR2(150) NOT NULL Object Value 2
8 PTKEYVALUE3 Character(150) VARCHAR2(150) NOT NULL Object Value 3
9 PTKEYVALUE4 Character(150) VARCHAR2(150) NOT NULL Object Value 4
10 PTKEYVALUE5 Character(150) VARCHAR2(150) NOT NULL Object Value 5
11 PTKEYVALUE6 Character(150) VARCHAR2(150) NOT NULL Object Value 6
12 PTKEYVALUE7 Character(150) VARCHAR2(150) NOT NULL Object Value 7
13 PTKEYVALUE8 Character(150) VARCHAR2(150) NOT NULL Object Value 8
14 PTIA_COUNTER Number(10,0) DECIMAL(10) NOT NULL PTIA Counter