eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: PV.PV_PG_ENRL_REQUESTS

Object Details

Object Name:	PV_PG_ENRL_REQUESTS
Object Type:	TABLE
Owner:	PV
FND Design Data:	PV.PV_PG_ENRL_REQUESTS
Subobject Name:
Status:	VALID

PV_PG_ENRL_REQUESTS stores the data related to enrollment request that is submitted by partner user for membership into various programs.
ENROLLMENT_TYPE_CODE identifies different types of enrollment requests, like New, Renewal, Upgrade, or Downgrade. REQUEST_INITIATED_BY_CODE identifies how the request is created - either by PARTNER user or by SYSTEM (used only for downgrades).
If the enrollment request is created because of invitations sent by vendor user, INVITE_HEADER_ID captures that information.
SCORE_RESULT_CODE stores the automatic scoring result(Success or Fail) after comparing the enrollment questionnarie data to program's requirements data.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PV_PG_ENRL_REQUESTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ENRL_REQUEST_ID
PV_PG_ENRL_REQUESTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARTNER_ID
PV_PG_ENRL_REQUESTS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROGRAM_ID
PV_PG_ENRL_REQUESTS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REQUESTOR_RESOURCE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ENRL_REQUEST_ID	NUMBER		Yes	Unique Identifier
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	This column is used for locking purposes
PROGRAM_ID	NUMBER		Yes	Foreign key to Program Id for which enrollment request is submitted for enrollment.
PARTNER_ID	NUMBER		Yes	Foreign key to Partner Organization Relatiship Id who submitted enrollment request
CUSTOM_SETUP_ID	NUMBER		Yes	Foreing key to Custom Setup Id that determines cuecard
REQUESTOR_RESOURCE_ID	NUMBER		Yes	Partner User's resource id that submitted the enrollment request
REQUEST_STATUS_CODE	VARCHAR2	(30)	Yes	Enrollment Request Status - lookup
ENROLLMENT_TYPE_CODE	VARCHAR2	(30)	Yes	Enrollment Type Code - New/Upgrade/Renew/Downgrade - Lookup
REQUEST_SUBMISSION_DATE	DATE			Enrollment Request submission date
ORDER_HEADER_ID	NUMBER			Foreign Key to OM order header id, when payment is collected for the enrollment request through order
CONTRACT_ID	NUMBER			Foreign Key to OKC contract id, that signed by partner for the program enrollment
REQUEST_INITIATED_BY_CODE	VARCHAR2	(30)	Yes	Whether the enrollment request is initiated manually, or automatically by system
INVITE_HEADER_ID	NUMBER			Foreign key to Invite Header Id if enrollment request is created because of an invitation
TENTATIVE_START_DATE	DATE			Tentative start date of membership at the time of creation of enrollment request
TENTATIVE_END_DATE	DATE			Tentative end date of membership at the time of creation of enrollment request
CONTRACT_STATUS_CODE	VARCHAR2	(30)		Contract Status Code - lookup
PAYMENT_STATUS_CODE	VARCHAR2	(30)		Payment Status Code in case of orders - Lookup
SCORE_RESULT_CODE	VARCHAR2	(30)		Automatic Scoring Result Code - Pass/Fail/Not Evaluated - Lookup
CREATED_BY	NUMBER	(15)	Yes	Standard WHO column
CREATION_DATE	DATE		Yes	Standard WHO column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO column
LAST_UPDATE_DATE	DATE		Yes	Standard WHO column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO column
MEMBERSHIP_FEE	NUMBER			Membership fee
TRANS_CURR_CODE	VARCHAR2	(15)		Transaction currency code.
DEPENDENT_PROGRAM_ID	NUMBER			Dependent program ID.
CONTRACT_BINDING_CONTACT_ID	NUMBER			Id of the contact who signed the contract
CONTRACT_SIGNED_DATE	DATE			Date when the enrollment contact was signed
TRXN_EXTENSION_ID	NUMBER			Reference to credit card payment details
ATTRIBUTE1	VARCHAR2	(240)		Attribute
ATTRIBUTE2	VARCHAR2	(240)		Attribute
ATTRIBUTE3	VARCHAR2	(240)		Attribute
ATTRIBUTE4	VARCHAR2	(240)		Attribute
ATTRIBUTE5	VARCHAR2	(240)		Attribute
ATTRIBUTE6	VARCHAR2	(240)		Attribute
ATTRIBUTE7	VARCHAR2	(240)		Attribute
ATTRIBUTE8	VARCHAR2	(240)		Attribute
ATTRIBUTE9	VARCHAR2	(240)		Attribute
ATTRIBUTE10	VARCHAR2	(240)		Attribute
ATTRIBUTE11	VARCHAR2	(240)		Attribute
ATTRIBUTE12	VARCHAR2	(240)		Attribute
ATTRIBUTE13	VARCHAR2	(240)		Attribute
ATTRIBUTE14	VARCHAR2	(240)		Attribute
ATTRIBUTE15	VARCHAR2	(240)		Attribute

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ENRL_REQUEST_ID
,      OBJECT_VERSION_NUMBER
,      PROGRAM_ID
,      PARTNER_ID
,      CUSTOM_SETUP_ID
,      REQUESTOR_RESOURCE_ID
,      REQUEST_STATUS_CODE
,      ENROLLMENT_TYPE_CODE
,      REQUEST_SUBMISSION_DATE
,      ORDER_HEADER_ID
,      CONTRACT_ID
,      REQUEST_INITIATED_BY_CODE
,      INVITE_HEADER_ID
,      TENTATIVE_START_DATE
,      TENTATIVE_END_DATE
,      CONTRACT_STATUS_CODE
,      PAYMENT_STATUS_CODE
,      SCORE_RESULT_CODE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      MEMBERSHIP_FEE
,      TRANS_CURR_CODE
,      DEPENDENT_PROGRAM_ID
,      CONTRACT_BINDING_CONTACT_ID
,      CONTRACT_SIGNED_DATE
,      TRXN_EXTENSION_ID
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
FROM PV.PV_PG_ENRL_REQUESTS;

Dependencies

[top of page]

PV.PV_PG_ENRL_REQUESTS does not reference any database object

PV.PV_PG_ENRL_REQUESTS is referenced by following:

APPS: PV_PG_ENRL_REQUESTS