EOCC_TRKATT_H2

(SQL Table)
Index Back

Archival Record

Archival Record for Attachment Cross Ref Table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
2 MARKET Character(3) VARCHAR2(3) NOT NULL Market
3 EOCC_KEY1_VAL Character(65) VARCHAR2(65) NOT NULL Key 1 Value
4 EOCC_KEY2_VAL Character(65) VARCHAR2(65) NOT NULL Key 2 Value
5 EOCC_KEY3_VAL Character(65) VARCHAR2(65) NOT NULL Key 3 Value
6 EOCC_KEY4_VAL Character(65) VARCHAR2(65) NOT NULL Key 4 Value
7 EOCC_KEY5_VAL Character(65) VARCHAR2(65) NOT NULL Key 5 Value
8 EOCC_KEY6_VAL Character(65) VARCHAR2(65) NOT NULL Key 6 Value
9 EOCC_KEY7_VAL Character(65) VARCHAR2(65) NOT NULL Key 7 Value
10 EOCC_KEY8_VAL Character(65) VARCHAR2(65) NOT NULL Key 8 Value
11 EOCC_KEY9_VAL Character(65) VARCHAR2(65) NOT NULL Key 9 Value
12 EOCC_KEY10_VAL Character(65) VARCHAR2(65) NOT NULL Key 10 Value
13 EOCC_KEY11_VAL Character(65) VARCHAR2(65) NOT NULL Key 11 Value
14 EOCC_KEY12_VAL Character(65) VARCHAR2(65) NOT NULL Key 12 Value
15 EOCC_FLDSEQNO Number(31,0) DECIMAL(31) NOT NULL Change Tracking Sequence Number
16 EOCC_ATT_SEQ Character(100) VARCHAR2(100) NOT NULL Sequences
17 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename
18 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File
19 EOCC_FILE_DESCR Character(100) VARCHAR2(100) NOT NULL Description
20 EOCC_ATT_DTTM DateTime(26) TIMESTAMP Date/Time Stamp
21 EOCC_ATT_OPR Character(30) VARCHAR2(30) NOT NULL User
22 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).
23 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number