# |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
1 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
2 |
AUC_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Event ID
|
3 |
AUC_ROUND |
Number(5,0) |
INTEGER NOT NULL |
Event Round
|
4 |
AUC_VERSION |
Number(5,0) |
INTEGER NOT NULL |
Event Version
|
5 |
RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
|
6 |
FIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
|
7 |
CHNG_DTTM |
DateTime(26) |
TIMESTAMP |
Change Request Date/Time
|
8 |
AUC_COLLAB_SEQNUM |
Number(3,0) |
SMALLINT NOT NULL |
Collaboration Sequence number
|
9 |
AUC_COLLAB_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Collaborator OPRID
|
10 |
AUC_COLLAB_NBR |
Number(4,0) |
SMALLINT NOT NULL |
Random Collab Log Nbr
|
11 |
COMMENTS_2000 |
Long Character |
CLOB |
Comment Text
|