# |
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
|