RA_RECR_CTR_VW

(SQL View)
 Index Back

Marketing Center

Marketing Center Prompt view on Recruiting Centers

SELECT DISTINCT CS_INSTITUTION , %Substring(RA_HE_CENTER_ID,1,4) , DESCR FROM %Table(RA_UD_MKTCENTER) WHERE RA_HE_CENTER_TYPE='R' 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