RI_HE_EVENT_VW(SQL View) |
Index Back |
|---|---|
Event viewEvent view for 360 higher education, event node. Qualified Union with different relation for DB2 (ie, e=ee,=ll,s=ss) |
| SELECT l.BO_ID , l.ROLE_TYPE_ID , e.BUSINESS_UNIT , e.RAE_EVENT_ID , 0 , 0 , 0 , e.RAE_EVENT_NAME , e.RAE_EVENTSTATUS_CD , e.START_DATE , e.END_DATE , l.BO_REL_ID , l.BO_ID_COMPANY , l.ROLE_TYPE_ID_ORG , l.RA_ADD_STATUS , l.RAE_INVITED_YN , l.RAE_ATTENDED_YN , l.RAE_FUTNOTFY_YN , l.RAE_REG_REASON_CD , l.RAE_ACCEPT_DATE , e.RAE_RSVP_DATE , e.BO_ID_OWNER , s.OPRID , %subrec(RB_AUDIT_SBR, e) FROM PS_RAE_EVENT e , PS_RAE_EVENT_LIST l , PS_RAE_EVTSCRTY_VW s WHERE e.BUSINESS_UNIT = l.BUSINESS_UNIT AND e.RAE_EVENT_ID = l.RAE_EVENT_ID AND l.ROLE_TYPE_ID <> 8 AND e.BUSINESS_UNIT = s.BUSINESS_UNIT AND e.RAE_EVENT_ID = s.RAE_EVENT_ID UNION ALL SELECT ll.BO_ID_COMPANY , ll.ROLE_TYPE_ID_ORG , ee.BUSINESS_UNIT , ee.RAE_EVENT_ID , ll.BO_ID , ll.ROLE_TYPE_ID , 0 , ee.RAE_EVENT_NAME , ee.RAE_EVENTSTATUS_CD , ee.START_DATE , ee.END_DATE , ll.BO_REL_ID , ll.BO_ID_COMPANY , ll.ROLE_TYPE_ID_ORG , ll.RA_ADD_STATUS , ll.RAE_INVITED_YN , ll.RAE_ATTENDED_YN , ll.RAE_FUTNOTFY_YN , ll.RAE_REG_REASON_CD , ll.RAE_ACCEPT_DATE , ee.RAE_RSVP_DATE , ee.BO_ID_OWNER , ss.OPRID , %subrec(RB_AUDIT_SBR, ee) FROM PS_RAE_EVENT ee , PS_RAE_EVENT_LIST ll , PS_RAE_EVTSCRTY_VW ss WHERE ee.BUSINESS_UNIT = ll.BUSINESS_UNIT AND ee.RAE_EVENT_ID = ll.RAE_EVENT_ID AND ll.ROLE_TYPE_ID = 8 AND ee.BUSINESS_UNIT = ss.BUSINESS_UNIT AND ee.RAE_EVENT_ID = ss.RAE_EVENT_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BO_ID_CUST |
Number(31,0) | DECIMAL(31) NOT NULL | This field stores the Business Object ID for the customer. |
| 2 | ROLE_TYPE_ID_CUST |
Number(12,0) | DECIMAL(12) NOT NULL | Stores ROLE_TYPE_ID for the customer |
| 3 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 4 | RAE_EVENT_ID |
Character(15) | VARCHAR2(15) NOT NULL | Marketing - Campaign Identification field. Character field that will contain a generated campaign or free form entered campaign id. |
| 5 | BO_ID_CONTACT | Number(31,0) | DECIMAL(31) NOT NULL | This field indicates the Business Object ID for the contact. |
| 6 | ROLE_TYPE_ID_CNTCT | Number(12,0) | DECIMAL(12) NOT NULL | Stores ROLE_TYPE_ID for the contact |
| 7 | BO_ID_PARTNER | Signed Number(32,0) | DECIMAL(31) NOT NULL | Business Object ID of Partner Company. |
| 8 | RAE_EVENT_NAME | Character(50) | VARCHAR2(50) NOT NULL | Campaign Name - field containing the name of the campaign. |
| 9 | RAE_EVENTSTATUS_CD | Character(4) | VARCHAR2(4) NOT NULL |
Valid Campaign and Wave Status Codes
APPR=Approved CMPL=Completed DCLN=Declined EXEC=Executing IREV=In Review NEW=New STOP=Stopped |
| 10 | START_DATE | Date(10) | DATE | Start Date for Gen Standing PO |
| 11 | END_DATE | Date(10) | DATE | End date field to store an end date. |
| 12 | BO_REL_ID | Signed Number(32,0) | DECIMAL(31) NOT NULL | Relationship ID of a Business Object |
| 13 | BO_ID_COMPANY | Signed Number(32,0) | DECIMAL(31) NOT NULL | Business Object ID |
| 14 | ROLE_TYPE_ID_ORG | Number(12,0) | DECIMAL(12) NOT NULL | Organization Role Type ID |
| 15 | RA_ADD_STATUS | Character(4) | VARCHAR2(4) NOT NULL |
Member added status: Auto Added or Manually Added
A=Auto Added M=Manually Added |
| 16 | RAE_INVITED_YN | Character(1) | VARCHAR2(1) NOT NULL |
Events - invited status y/n indicator
N=No Y=Yes |
| 17 | RAE_ATTENDED_YN | Character(1) | VARCHAR2(1) NOT NULL |
Yes / No field used to mark attended on a participant of an Event
N=No Y=Yes |
| 18 | RAE_FUTNOTFY_YN | Character(1) | VARCHAR2(1) NOT NULL |
Events - future notification status y/n indicator
N=No Y=Yes |
| 19 | RAE_REG_REASON_CD | Character(4) | VARCHAR2(4) NOT NULL |
Marketing Events - Registration Reason Code
DCLN=Declined RGST=Registered WAIT=Waitlisted |
| 20 | RAE_ACCEPT_DATE | Date(10) | DATE | Sub Event list - accepted Date |
| 21 | RAE_RSVP_DATE | Date(10) | DATE | Sub Event - RSVP Date |
| 22 | BO_ID_OWNER | Number(31,0) | DECIMAL(31) NOT NULL | Financial Account Business Object ID |
| 23 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 24 | ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | This is a datetime field for record creation. |
| 25 | ROW_ADDED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who added the row. |
| 26 | ROW_LASTMANT_DTTM | DateTime(26) | TIMESTAMP | The date and time that the row was last updated. |
| 27 | ROW_LASTMANT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who last modified the row. |
| 28 | SYNCID | Number(10,0) | DECIMAL(10) NOT NULL | The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle. |
| 29 | SYNCDTTM | DateTime(26) | TIMESTAMP | Synchronization Last Update Date Time |