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.

VIEW: PV.PV_PG_ENRL_REQUESTS#

Source

View Text - Preformatted


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

View Text - HTML Formatted

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