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
1=LIKE 2=NOT LIKE 3== 4=> 5=< 6=<> 7=>= 8=<= |
| 16 | EOCC_FLDSEQNO | Number(31,0) | DECIMAL(31) NOT NULL |
Change Tracking Sequence Number
Default Value: 0 |