EOCC_CHGTRK_HDR

(SQL View)
 Index Back

Union of ChgTrk Header 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 ,EOCC_KEY1_NAME ,EOCC_KEY2_NAME ,EOCC_KEY3_NAME ,EOCC_KEY4_NAME ,EOCC_KEY5_NAME ,EOCC_KEY6_NAME ,EOCC_KEY7_NAME ,EOCC_KEY8_NAME ,EOCC_KEY9_NAME ,EOCC_KEY10_NAME ,EOCC_KEY11_NAME ,EOCC_KEY12_NAME ,EOCC_CHGTRK_LBL1 ,EOCC_CHGTRK_LBL2 ,EOCC_CHGTRK_LBL3 ,EOCC_CHGTRK_LBL4 ,EOCC_CHGTRK_LBL5 ,EOCC_CHGTRK_LBL6 ,EOCC_CHGTRK_LBL7 ,EOCC_CHGTRK_LBL8 ,EOCC_CHGTRK_LBL9 ,EOCC_CHGTRK_LBL10 ,EOCC_CHGTRK_LBL11 ,EOCC_CHGTRK_LBL12 FROM PS_EOCC_TRK_HDR1 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_KEY1_NAME ,EOCC_KEY2_NAME ,EOCC_KEY3_NAME ,EOCC_KEY4_NAME ,EOCC_KEY5_NAME ,EOCC_KEY6_NAME ,EOCC_KEY7_NAME ,EOCC_KEY8_NAME ,EOCC_KEY9_NAME ,EOCC_KEY10_NAME ,EOCC_KEY11_NAME ,EOCC_KEY12_NAME ,EOCC_CHGTRK_LBL1 ,EOCC_CHGTRK_LBL2 ,EOCC_CHGTRK_LBL3 ,EOCC_CHGTRK_LBL4 ,EOCC_CHGTRK_LBL5 ,EOCC_CHGTRK_LBL6 ,EOCC_CHGTRK_LBL7 ,EOCC_CHGTRK_LBL8 ,EOCC_CHGTRK_LBL9 ,EOCC_CHGTRK_LBL10 ,EOCC_CHGTRK_LBL11 ,EOCC_CHGTRK_LBL12 FROM PS_EOCC_TRK_HDR2 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_KEY1_NAME ,EOCC_KEY2_NAME ,EOCC_KEY3_NAME ,EOCC_KEY4_NAME ,EOCC_KEY5_NAME ,EOCC_KEY6_NAME ,EOCC_KEY7_NAME ,EOCC_KEY8_NAME ,EOCC_KEY9_NAME ,EOCC_KEY10_NAME ,EOCC_KEY11_NAME ,EOCC_KEY12_NAME ,EOCC_CHGTRK_LBL1 ,EOCC_CHGTRK_LBL2 ,EOCC_CHGTRK_LBL3 ,EOCC_CHGTRK_LBL4 ,EOCC_CHGTRK_LBL5 ,EOCC_CHGTRK_LBL6 ,EOCC_CHGTRK_LBL7 ,EOCC_CHGTRK_LBL8 ,EOCC_CHGTRK_LBL9 ,EOCC_CHGTRK_LBL10 ,EOCC_CHGTRK_LBL11 ,EOCC_CHGTRK_LBL12 FROM PS_EOCC_TRK_HDR3 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_KEY1_NAME ,EOCC_KEY2_NAME ,EOCC_KEY3_NAME ,EOCC_KEY4_NAME ,EOCC_KEY5_NAME ,EOCC_KEY6_NAME ,EOCC_KEY7_NAME ,EOCC_KEY8_NAME ,EOCC_KEY9_NAME ,EOCC_KEY10_NAME ,EOCC_KEY11_NAME ,EOCC_KEY12_NAME ,EOCC_CHGTRK_LBL1 ,EOCC_CHGTRK_LBL2 ,EOCC_CHGTRK_LBL3 ,EOCC_CHGTRK_LBL4 ,EOCC_CHGTRK_LBL5 ,EOCC_CHGTRK_LBL6 ,EOCC_CHGTRK_LBL7 ,EOCC_CHGTRK_LBL8 ,EOCC_CHGTRK_LBL9 ,EOCC_CHGTRK_LBL10 ,EOCC_CHGTRK_LBL11 ,EOCC_CHGTRK_LBL12 FROM PS_EOCC_TRK_HDR4 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_KEY1_NAME ,EOCC_KEY2_NAME ,EOCC_KEY3_NAME ,EOCC_KEY4_NAME ,EOCC_KEY5_NAME ,EOCC_KEY6_NAME ,EOCC_KEY7_NAME ,EOCC_KEY8_NAME ,EOCC_KEY9_NAME ,EOCC_KEY10_NAME ,EOCC_KEY11_NAME ,EOCC_KEY12_NAME ,EOCC_CHGTRK_LBL1 ,EOCC_CHGTRK_LBL2 ,EOCC_CHGTRK_LBL3 ,EOCC_CHGTRK_LBL4 ,EOCC_CHGTRK_LBL5 ,EOCC_CHGTRK_LBL6 ,EOCC_CHGTRK_LBL7 ,EOCC_CHGTRK_LBL8 ,EOCC_CHGTRK_LBL9 ,EOCC_CHGTRK_LBL10 ,EOCC_CHGTRK_LBL11 ,EOCC_CHGTRK_LBL12 FROM PS_EOCC_TRK_HDR5 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_KEY1_NAME ,EOCC_KEY2_NAME ,EOCC_KEY3_NAME ,EOCC_KEY4_NAME ,EOCC_KEY5_NAME ,EOCC_KEY6_NAME ,EOCC_KEY7_NAME ,EOCC_KEY8_NAME ,EOCC_KEY9_NAME ,EOCC_KEY10_NAME ,EOCC_KEY11_NAME ,EOCC_KEY12_NAME ,EOCC_CHGTRK_LBL1 ,EOCC_CHGTRK_LBL2 ,EOCC_CHGTRK_LBL3 ,EOCC_CHGTRK_LBL4 ,EOCC_CHGTRK_LBL5 ,EOCC_CHGTRK_LBL6 ,EOCC_CHGTRK_LBL7 ,EOCC_CHGTRK_LBL8 ,EOCC_CHGTRK_LBL9 ,EOCC_CHGTRK_LBL10 ,EOCC_CHGTRK_LBL11 ,EOCC_CHGTRK_LBL12 FROM PS_EOCC_TRK_HDR6 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_KEY1_NAME ,EOCC_KEY2_NAME ,EOCC_KEY3_NAME ,EOCC_KEY4_NAME ,EOCC_KEY5_NAME ,EOCC_KEY6_NAME ,EOCC_KEY7_NAME ,EOCC_KEY8_NAME ,EOCC_KEY9_NAME ,EOCC_KEY10_NAME ,EOCC_KEY11_NAME ,EOCC_KEY12_NAME ,EOCC_CHGTRK_LBL1 ,EOCC_CHGTRK_LBL2 ,EOCC_CHGTRK_LBL3 ,EOCC_CHGTRK_LBL4 ,EOCC_CHGTRK_LBL5 ,EOCC_CHGTRK_LBL6 ,EOCC_CHGTRK_LBL7 ,EOCC_CHGTRK_LBL8 ,EOCC_CHGTRK_LBL9 ,EOCC_CHGTRK_LBL10 ,EOCC_CHGTRK_LBL11 ,EOCC_CHGTRK_LBL12 FROM PS_EOCC_TRK_HDR7 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_KEY1_NAME ,EOCC_KEY2_NAME ,EOCC_KEY3_NAME ,EOCC_KEY4_NAME ,EOCC_KEY5_NAME ,EOCC_KEY6_NAME ,EOCC_KEY7_NAME ,EOCC_KEY8_NAME ,EOCC_KEY9_NAME ,EOCC_KEY10_NAME ,EOCC_KEY11_NAME ,EOCC_KEY12_NAME ,EOCC_CHGTRK_LBL1 ,EOCC_CHGTRK_LBL2 ,EOCC_CHGTRK_LBL3 ,EOCC_CHGTRK_LBL4 ,EOCC_CHGTRK_LBL5 ,EOCC_CHGTRK_LBL6 ,EOCC_CHGTRK_LBL7 ,EOCC_CHGTRK_LBL8 ,EOCC_CHGTRK_LBL9 ,EOCC_CHGTRK_LBL10 ,EOCC_CHGTRK_LBL11 ,EOCC_CHGTRK_LBL12 FROM PS_EOCC_TRK_HDR8 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_KEY1_NAME ,EOCC_KEY2_NAME ,EOCC_KEY3_NAME ,EOCC_KEY4_NAME ,EOCC_KEY5_NAME ,EOCC_KEY6_NAME ,EOCC_KEY7_NAME ,EOCC_KEY8_NAME ,EOCC_KEY9_NAME ,EOCC_KEY10_NAME ,EOCC_KEY11_NAME ,EOCC_KEY12_NAME ,EOCC_CHGTRK_LBL1 ,EOCC_CHGTRK_LBL2 ,EOCC_CHGTRK_LBL3 ,EOCC_CHGTRK_LBL4 ,EOCC_CHGTRK_LBL5 ,EOCC_CHGTRK_LBL6 ,EOCC_CHGTRK_LBL7 ,EOCC_CHGTRK_LBL8 ,EOCC_CHGTRK_LBL9 ,EOCC_CHGTRK_LBL10 ,EOCC_CHGTRK_LBL11 ,EOCC_CHGTRK_LBL12 FROM PS_EOCC_TRK_HDR9 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_KEY1_NAME ,EOCC_KEY2_NAME ,EOCC_KEY3_NAME ,EOCC_KEY4_NAME ,EOCC_KEY5_NAME ,EOCC_KEY6_NAME ,EOCC_KEY7_NAME ,EOCC_KEY8_NAME ,EOCC_KEY9_NAME ,EOCC_KEY10_NAME ,EOCC_KEY11_NAME ,EOCC_KEY12_NAME ,EOCC_CHGTRK_LBL1 ,EOCC_CHGTRK_LBL2 ,EOCC_CHGTRK_LBL3 ,EOCC_CHGTRK_LBL4 ,EOCC_CHGTRK_LBL5 ,EOCC_CHGTRK_LBL6 ,EOCC_CHGTRK_LBL7 ,EOCC_CHGTRK_LBL8 ,EOCC_CHGTRK_LBL9 ,EOCC_CHGTRK_LBL10 ,EOCC_CHGTRK_LBL11 ,EOCC_CHGTRK_LBL12 FROM PS_EOCC_TRK_HDR10

# 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_KEY1_NAME Character(18) VARCHAR2(18) NOT NULL Key 1 Field Name
16 EOCC_KEY2_NAME Character(18) VARCHAR2(18) NOT NULL Key 2 Field Name
17 EOCC_KEY3_NAME Character(18) VARCHAR2(18) NOT NULL Key 3 Field Name
18 EOCC_KEY4_NAME Character(18) VARCHAR2(18) NOT NULL Key 4 Field Name
19 EOCC_KEY5_NAME Character(18) VARCHAR2(18) NOT NULL Key 5 Field Name
20 EOCC_KEY6_NAME Character(18) VARCHAR2(18) NOT NULL Key 6 Field Name
21 EOCC_KEY7_NAME Character(18) VARCHAR2(18) NOT NULL Key 7 Field Name
22 EOCC_KEY8_NAME Character(18) VARCHAR2(18) NOT NULL Key 8 Field Name
23 EOCC_KEY9_NAME Character(18) VARCHAR2(18) NOT NULL Key 9 Field Name
24 EOCC_KEY10_NAME Character(18) VARCHAR2(18) NOT NULL Key 10 Field Name
25 EOCC_KEY11_NAME Character(18) VARCHAR2(18) NOT NULL Key 11 Field Name
26 EOCC_KEY12_NAME Character(18) VARCHAR2(18) NOT NULL Key 12 Field Name
27 EOCC_CHGTRK_LBL1 Character(90) VARCHAR2(90) NOT NULL Change Tracking
28 EOCC_CHGTRK_LBL2 Character(90) VARCHAR2(90) NOT NULL Change Tracking
29 EOCC_CHGTRK_LBL3 Character(90) VARCHAR2(90) NOT NULL Change Tracking
30 EOCC_CHGTRK_LBL4 Character(90) VARCHAR2(90) NOT NULL Change Tracking
31 EOCC_CHGTRK_LBL5 Character(90) VARCHAR2(90) NOT NULL Change Tracking
32 EOCC_CHGTRK_LBL6 Character(90) VARCHAR2(90) NOT NULL Change Tracking
33 EOCC_CHGTRK_LBL7 Character(90) VARCHAR2(90) NOT NULL Change Tracking
34 EOCC_CHGTRK_LBL8 Character(90) VARCHAR2(90) NOT NULL Change Tracking
35 EOCC_CHGTRK_LBL9 Character(90) VARCHAR2(90) NOT NULL Change Tracking
36 EOCC_CHGTRK_LBL10 Character(90) VARCHAR2(90) NOT NULL Change Tracking
37 EOCC_CHGTRK_LBL11 Character(90) VARCHAR2(90) NOT NULL Change Tracking
38 EOCC_CHGTRK_LBL12 Character(90) VARCHAR2(90) NOT NULL Change Tracking