RI_HE_EVENT_CVW

(SQL View)
 Index Back

Event view

Event view for 360 higher education, event node. It's permission list security view.

SELECT e.BO_ID_CUST , e.ROLE_TYPE_ID_CUST , e.BUSINESS_UNIT , e.RAE_EVENT_ID , e.BO_ID_CONTACT , e.ROLE_TYPE_ID_CNTCT , e.BO_ID_PARTNER , e.RAE_EVENT_NAME , e.RAE_EVENTSTATUS_CD , e.START_DATE , e.END_DATE , e.BO_REL_ID , e.BO_ID_COMPANY , e.ROLE_TYPE_ID_ORG , e.RA_ADD_STATUS , e.RAE_INVITED_YN , e.RAE_ATTENDED_YN , e.RAE_FUTNOTFY_YN , e.RAE_REG_REASON_CD , e.RAE_ACCEPT_DATE , e.RAE_RSVP_DATE , e.BO_ID_OWNER , o.OPRID , %subrec(RB_AUDIT_SBR, e) FROM PS_RI_HE_EVENT_VW e , PS_SEC_BU_CLS c , PSOPRDEFN o WHERE e.BUSINESS_UNIT = c.BUSINESS_UNIT AND c.OPRCLASS = o.ROWSECCLASS AND e.OPRID = o.OPRID

# 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