OPPORTUNITY_IDSEQ_NUMRSFD_OPP_HIST_V(SQL View) |
Index Back |
|---|---|
Oppy Action History tableAction History table for Opportunities |
| SELECT A.OPPORTUNITY_ID , A.SEQ_NUM , B.OPPORTUNITY_NAME , B.PERSON_ID , REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(%Upper(A.EVENTNAME) , 'OPPORTUNITY ' , '') , 'OPP' ,'') , 'CHANGED' , '') , 'IS CHA' , '') , 'IS ' , '') , A.OLD_VALUE , A.NEW_VALUE , C.PERSON_ID , A.ROW_LASTMANT_DTTM FROM PS_RSF_OPP_HISTORY A , PS_RSF_OPPORTUNITY B , PSOPRALIAS C WHERE A.OPPORTUNITY_ID = B.OPPORTUNITY_ID AND A.ROW_LASTMANT_OPRID = C.OPRID AND C.OPRALIASTYPE = 'PER' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPPORTUNITY_ID |
Character(15) | VARCHAR2(15) NOT NULL | Opportunity ID |
| 2 | SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Sequence |
| 3 | OPPORTUNITY_NAME | Character(50) | VARCHAR2(50) NOT NULL | Opportunity Name - User Enters this field in Mixed Case. |
| 4 | PERSON_ID | Character(15) | VARCHAR2(15) NOT NULL | Person ID |
| 5 | EVENTNAME | Character(30) | VARCHAR2(30) NOT NULL | Defines a routing event for PS Workflow |
| 6 | OLD_VALUE | Character(100) | VARCHAR2(100) NOT NULL | Old Value |
| 7 | NEW_VALUE | Character(100) | VARCHAR2(100) NOT NULL | New Value |
| 8 | PERSON_ID_USER | Character(15) | VARCHAR2(15) NOT NULL | Person ID |
| 9 | ROW_LASTMANT_DTTM | DateTime(26) | TIMESTAMP | The date and time that the row was last updated. |