EOCC_TRKHDR_H10

(SQL Table)
Index Back

Archival Record

Archival Record for Header Log Table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).
2 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number
3 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
4 MARKET Character(3) VARCHAR2(3) NOT NULL Market
5 EOCC_KEY1_VAL Character(65) VARCHAR2(65) NOT NULL Key 1 Value
6 EOCC_KEY2_VAL Character(65) VARCHAR2(65) NOT NULL Key 2 Value
7 EOCC_KEY3_VAL Character(65) VARCHAR2(65) NOT NULL Key 3 Value
8 EOCC_KEY4_VAL Character(65) VARCHAR2(65) NOT NULL Key 4 Value
9 EOCC_KEY5_VAL Character(65) VARCHAR2(65) NOT NULL Key 5 Value
10 EOCC_KEY6_VAL Character(65) VARCHAR2(65) NOT NULL Key 6 Value
11 EOCC_KEY7_VAL Character(65) VARCHAR2(65) NOT NULL Key 7 Value
12 EOCC_KEY8_VAL Character(65) VARCHAR2(65) NOT NULL Key 8 Value
13 EOCC_KEY9_VAL Character(65) VARCHAR2(65) NOT NULL Key 9 Value
14 EOCC_KEY10_VAL Character(65) VARCHAR2(65) NOT NULL Key 10 Value
15 EOCC_KEY11_VAL Character(65) VARCHAR2(65) NOT NULL Key 11 Value
16 EOCC_KEY12_VAL Character(65) VARCHAR2(65) NOT NULL Key 12 Value
17 EOCC_KEY1_NAME Character(18) VARCHAR2(18) NOT NULL Key 1 Field Name
18 EOCC_KEY2_NAME Character(18) VARCHAR2(18) NOT NULL Key 2 Field Name
19 EOCC_KEY3_NAME Character(18) VARCHAR2(18) NOT NULL Key 3 Field Name
20 EOCC_KEY4_NAME Character(18) VARCHAR2(18) NOT NULL Key 4 Field Name
21 EOCC_KEY5_NAME Character(18) VARCHAR2(18) NOT NULL Key 5 Field Name
22 EOCC_KEY6_NAME Character(18) VARCHAR2(18) NOT NULL Key 6 Field Name
23 EOCC_KEY7_NAME Character(18) VARCHAR2(18) NOT NULL Key 7 Field Name
24 EOCC_KEY8_NAME Character(18) VARCHAR2(18) NOT NULL Key 8 Field Name
25 EOCC_KEY9_NAME Character(18) VARCHAR2(18) NOT NULL Key 9 Field Name
26 EOCC_KEY10_NAME Character(18) VARCHAR2(18) NOT NULL Key 10 Field Name
27 EOCC_KEY11_NAME Character(18) VARCHAR2(18) NOT NULL Key 11 Field Name
28 EOCC_KEY12_NAME Character(18) VARCHAR2(18) NOT NULL Key 12 Field Name
29 EOCC_CHGTRK_LBL1 Character(90) VARCHAR2(90) NOT NULL Change Tracking
30 EOCC_CHGTRK_LBL2 Character(90) VARCHAR2(90) NOT NULL Change Tracking
31 EOCC_CHGTRK_LBL3 Character(90) VARCHAR2(90) NOT NULL Change Tracking
32 EOCC_CHGTRK_LBL4 Character(90) VARCHAR2(90) NOT NULL Change Tracking
33 EOCC_CHGTRK_LBL5 Character(90) VARCHAR2(90) NOT NULL Change Tracking
34 EOCC_CHGTRK_LBL6 Character(90) VARCHAR2(90) NOT NULL Change Tracking
35 EOCC_CHGTRK_LBL7 Character(90) VARCHAR2(90) NOT NULL Change Tracking
36 EOCC_CHGTRK_LBL8 Character(90) VARCHAR2(90) NOT NULL Change Tracking
37 EOCC_CHGTRK_LBL9 Character(90) VARCHAR2(90) NOT NULL Change Tracking
38 EOCC_CHGTRK_LBL10 Character(90) VARCHAR2(90) NOT NULL Change Tracking
39 EOCC_CHGTRK_LBL11 Character(90) VARCHAR2(90) NOT NULL Change Tracking
40 EOCC_CHGTRK_LBL12 Character(90) VARCHAR2(90) NOT NULL Change Tracking