RA_APPL_CTR_VW

(SQL View)
 Index Back

Marketing Center

Marketing Center Prompt view on Academic Centers

SELECT DISTINCT CS_INSTITUTION , %Substring(RA_HE_CENTER_ID,1,4) , DESCR FROM PS_RA_UD_MKTCENTER WHERE RA_HE_CENTER_TYPE='A' AND RA_HE_EIP_CREATE='Y' AND CS_INSTITUTION<>' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CS_INSTITUTION Character(5) VARCHAR2(5) NOT NULL CS_INSTITUTION is used in OLM Profile student admin Dialog for OLM/SA Integration.
2 CS_ADM_RECR_CTR Character(4) VARCHAR2(4) NOT NULL CS_ADM_RECR_CTR is used in OLM Profile student admin Dialog for OLM/SA Integration.
3 DESCR Character(30) VARCHAR2(30) NOT NULL Description