EOCC_CHGTRK_SVW(SQL View) |
Index Back |
---|---|
Change TrackingSearch View for change tracking (classic) |
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 FROM PS_EOCC_CHGTRK_HDR |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(18) | VARCHAR2(18) NOT NULL | Component Name | |
2 | Character(3) | VARCHAR2(3) NOT NULL | Market | |
3 | Character(65) | VARCHAR2(65) NOT NULL | Key 1 Value | |
4 | Character(65) | VARCHAR2(65) NOT NULL | Key 2 Value | |
5 | Character(65) | VARCHAR2(65) NOT NULL | Key 3 Value | |
6 | Character(65) | VARCHAR2(65) NOT NULL | Key 4 Value | |
7 | Character(65) | VARCHAR2(65) NOT NULL | Key 5 Value | |
8 | Character(65) | VARCHAR2(65) NOT NULL | Key 6 Value | |
9 | Character(65) | VARCHAR2(65) NOT NULL | Key 7 Value | |
10 | Character(65) | VARCHAR2(65) NOT NULL | Key 8 Value | |
11 | Character(65) | VARCHAR2(65) NOT NULL | Key 9 Value | |
12 | Character(65) | VARCHAR2(65) NOT NULL | Key 10 Value | |
13 | Character(65) | VARCHAR2(65) NOT NULL | Key 11 Value | |
14 | Character(65) | VARCHAR2(65) NOT NULL | Key 12 Value |