EOCC_CHGTRK_ATT

(SQL View)
 Index Back

Change Tracking Attachments


SELECT PNLGRPNAME ,MARKET ,EOCC_KEY1_VAL ,EOCC_KEY2_VAL ,EOCC_KEY3_VAL ,EOCC_KEY4_VAL ,EOCC_KEY5_VAL ,EOCC_KEY6_VAL ,EOCC_KEY7_VAL ,EOCC_KEY8_VAL ,EOCC_KEY9_VAL ,EOCC_KEY10_VAL ,EOCC_KEY11_VAL ,EOCC_KEY12_VAL ,EOCC_FLDSEQNO ,EOCC_ATT_SEQ ,ATTACHSYSFILENAME ,ATTACHUSERFILE ,EOCC_FILE_DESCR ,EOCC_ATT_DTTM ,EOCC_ATT_OPR FROM PS_EOCC_TRK_ATT1 UNION SELECT PNLGRPNAME ,MARKET ,EOCC_KEY1_VAL ,EOCC_KEY2_VAL ,EOCC_KEY3_VAL ,EOCC_KEY4_VAL ,EOCC_KEY5_VAL ,EOCC_KEY6_VAL ,EOCC_KEY7_VAL ,EOCC_KEY8_VAL ,EOCC_KEY9_VAL ,EOCC_KEY10_VAL ,EOCC_KEY11_VAL ,EOCC_KEY12_VAL ,EOCC_FLDSEQNO ,EOCC_ATT_SEQ ,ATTACHSYSFILENAME ,ATTACHUSERFILE ,EOCC_FILE_DESCR ,EOCC_ATT_DTTM ,EOCC_ATT_OPR FROM PS_EOCC_TRK_ATT2 UNION SELECT PNLGRPNAME ,MARKET ,EOCC_KEY1_VAL ,EOCC_KEY2_VAL ,EOCC_KEY3_VAL ,EOCC_KEY4_VAL ,EOCC_KEY5_VAL ,EOCC_KEY6_VAL ,EOCC_KEY7_VAL ,EOCC_KEY8_VAL ,EOCC_KEY9_VAL ,EOCC_KEY10_VAL ,EOCC_KEY11_VAL ,EOCC_KEY12_VAL ,EOCC_FLDSEQNO ,EOCC_ATT_SEQ ,ATTACHSYSFILENAME ,ATTACHUSERFILE ,EOCC_FILE_DESCR ,EOCC_ATT_DTTM ,EOCC_ATT_OPR FROM PS_EOCC_TRK_ATT3 UNION SELECT PNLGRPNAME ,MARKET ,EOCC_KEY1_VAL ,EOCC_KEY2_VAL ,EOCC_KEY3_VAL ,EOCC_KEY4_VAL ,EOCC_KEY5_VAL ,EOCC_KEY6_VAL ,EOCC_KEY7_VAL ,EOCC_KEY8_VAL ,EOCC_KEY9_VAL ,EOCC_KEY10_VAL ,EOCC_KEY11_VAL ,EOCC_KEY12_VAL ,EOCC_FLDSEQNO ,EOCC_ATT_SEQ ,ATTACHSYSFILENAME ,ATTACHUSERFILE ,EOCC_FILE_DESCR ,EOCC_ATT_DTTM ,EOCC_ATT_OPR FROM PS_EOCC_TRK_ATT4 UNION SELECT PNLGRPNAME ,MARKET ,EOCC_KEY1_VAL ,EOCC_KEY2_VAL ,EOCC_KEY3_VAL ,EOCC_KEY4_VAL ,EOCC_KEY5_VAL ,EOCC_KEY6_VAL ,EOCC_KEY7_VAL ,EOCC_KEY8_VAL ,EOCC_KEY9_VAL ,EOCC_KEY10_VAL ,EOCC_KEY11_VAL ,EOCC_KEY12_VAL ,EOCC_FLDSEQNO ,EOCC_ATT_SEQ ,ATTACHSYSFILENAME ,ATTACHUSERFILE ,EOCC_FILE_DESCR ,EOCC_ATT_DTTM ,EOCC_ATT_OPR FROM PS_EOCC_TRK_ATT5 UNION SELECT PNLGRPNAME ,MARKET ,EOCC_KEY1_VAL ,EOCC_KEY2_VAL ,EOCC_KEY3_VAL ,EOCC_KEY4_VAL ,EOCC_KEY5_VAL ,EOCC_KEY6_VAL ,EOCC_KEY7_VAL ,EOCC_KEY8_VAL ,EOCC_KEY9_VAL ,EOCC_KEY10_VAL ,EOCC_KEY11_VAL ,EOCC_KEY12_VAL ,EOCC_FLDSEQNO ,EOCC_ATT_SEQ ,ATTACHSYSFILENAME ,ATTACHUSERFILE ,EOCC_FILE_DESCR ,EOCC_ATT_DTTM ,EOCC_ATT_OPR FROM PS_EOCC_TRK_ATT6 UNION SELECT PNLGRPNAME ,MARKET ,EOCC_KEY1_VAL ,EOCC_KEY2_VAL ,EOCC_KEY3_VAL ,EOCC_KEY4_VAL ,EOCC_KEY5_VAL ,EOCC_KEY6_VAL ,EOCC_KEY7_VAL ,EOCC_KEY8_VAL ,EOCC_KEY9_VAL ,EOCC_KEY10_VAL ,EOCC_KEY11_VAL ,EOCC_KEY12_VAL ,EOCC_FLDSEQNO ,EOCC_ATT_SEQ ,ATTACHSYSFILENAME ,ATTACHUSERFILE ,EOCC_FILE_DESCR ,EOCC_ATT_DTTM ,EOCC_ATT_OPR FROM PS_EOCC_TRK_ATT7 UNION SELECT PNLGRPNAME ,MARKET ,EOCC_KEY1_VAL ,EOCC_KEY2_VAL ,EOCC_KEY3_VAL ,EOCC_KEY4_VAL ,EOCC_KEY5_VAL ,EOCC_KEY6_VAL ,EOCC_KEY7_VAL ,EOCC_KEY8_VAL ,EOCC_KEY9_VAL ,EOCC_KEY10_VAL ,EOCC_KEY11_VAL ,EOCC_KEY12_VAL ,EOCC_FLDSEQNO ,EOCC_ATT_SEQ ,ATTACHSYSFILENAME ,ATTACHUSERFILE ,EOCC_FILE_DESCR ,EOCC_ATT_DTTM ,EOCC_ATT_OPR FROM PS_EOCC_TRK_ATT8 UNION SELECT PNLGRPNAME ,MARKET ,EOCC_KEY1_VAL ,EOCC_KEY2_VAL ,EOCC_KEY3_VAL ,EOCC_KEY4_VAL ,EOCC_KEY5_VAL ,EOCC_KEY6_VAL ,EOCC_KEY7_VAL ,EOCC_KEY8_VAL ,EOCC_KEY9_VAL ,EOCC_KEY10_VAL ,EOCC_KEY11_VAL ,EOCC_KEY12_VAL ,EOCC_FLDSEQNO ,EOCC_ATT_SEQ ,ATTACHSYSFILENAME ,ATTACHUSERFILE ,EOCC_FILE_DESCR ,EOCC_ATT_DTTM ,EOCC_ATT_OPR FROM PS_EOCC_TRK_ATT9 UNION SELECT PNLGRPNAME ,MARKET ,EOCC_KEY1_VAL ,EOCC_KEY2_VAL ,EOCC_KEY3_VAL ,EOCC_KEY4_VAL ,EOCC_KEY5_VAL ,EOCC_KEY6_VAL ,EOCC_KEY7_VAL ,EOCC_KEY8_VAL ,EOCC_KEY9_VAL ,EOCC_KEY10_VAL ,EOCC_KEY11_VAL ,EOCC_KEY12_VAL ,EOCC_FLDSEQNO ,EOCC_ATT_SEQ ,ATTACHSYSFILENAME ,ATTACHUSERFILE ,EOCC_FILE_DESCR ,EOCC_ATT_DTTM ,EOCC_ATT_OPR FROM PS_EOCC_TRK_ATT10

# 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