AUC_COLLAB_CMMT

(SQL Table)
Index Back

Collaboration Comments

# 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