EOCC_CHGTRK_SEQ

(SQL View)
 Index Back

Union of ChgTrk Sequence Recs


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 , OPERATOR , EOCC_FLDSEQNO FROM PS_EOCC_TRK_SEQ1 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 , OPERATOR , EOCC_FLDSEQNO FROM PS_EOCC_TRK_SEQ2 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 , OPERATOR , EOCC_FLDSEQNO FROM PS_EOCC_TRK_SEQ3 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 , OPERATOR , EOCC_FLDSEQNO FROM PS_EOCC_TRK_SEQ4 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 , OPERATOR , EOCC_FLDSEQNO FROM PS_EOCC_TRK_SEQ5 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 , OPERATOR , EOCC_FLDSEQNO FROM PS_EOCC_TRK_SEQ6 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 , OPERATOR , EOCC_FLDSEQNO FROM PS_EOCC_TRK_SEQ7 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 , OPERATOR , EOCC_FLDSEQNO FROM PS_EOCC_TRK_SEQ8 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 , OPERATOR , EOCC_FLDSEQNO FROM PS_EOCC_TRK_SEQ9 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 , OPERATOR , EOCC_FLDSEQNO FROM PS_EOCC_TRK_SEQ10

# 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 OPERATOR Character(30) VARCHAR2(30) NOT NULL User ID
16 EOCC_FLDSEQNO Number(31,0) DECIMAL(31) NOT NULL Change Tracking Sequence Number

Default Value: 0