SSR_REQS_STDCOM

(SQL View)
 Index Back

Students Communication - PERC


SELECT A.COMMON_ID , B.ACAD_CAREER , A.INSTITUTION , B.STRM , B.CLASS_NBR , A.SEQ_3C , C.COMM_CATEGORY , A.SCC_LETTER_CD , D.DESCR , A.COMPLETED_DT , A.COMPLETED_COMM , A.UNSUCCESSFUL , A.OUTCOME_REASON , A.COMM_ID , A.COMPLETED_ID , A.COMM_DT , A.COMM_DTTM FROM PS_COMMUNICATION A , PS_VAR_DATA_SENR B , PS_INSTALLATION_SR C , PS_SCC_STN_LTR_TBL D WHERE A.COMMON_ID = B.COMMON_ID AND A.VAR_DATA_SEQ = B.VAR_DATA_SEQ AND A.COMM_CATEGORY = C.COMM_CATEGORY AND A.SCC_LETTER_CD = D.SCC_LETTER_CD

  • Related Language Record: SSR_REQS_SCOM_L

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COMMON_ID Character(11) VARCHAR2(11) NOT NULL Common ID to store Personal ID / Ext Org ID value
    2 ACAD_CAREER Character(4) VARCHAR2(4) NOT NULL Academic Career
    BAC=Bachelor (NLD)
    BBL=Vocational Coaching (NLD)
    BOL=Vocational Training (NLD)
    BUSN=Graduate Business
    CNED=Continuing Education
    CRED=Semester Credit
    EDU=Education (NLD)
    EXED=Extended Education
    GRAD=Graduate
    LAW=Law
    MEDS=Medical School
    NONA=Non Award
    PGRD=Postgraduate
    RSCH=Research
    TECH=Technical
    UENG=Undergraduate Engineering
    UGRD=Undergraduate
    VAVO=Advanced General Educ. (NLD)
    VETM=Veterinary Medicine
    3 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
    4 STRM Character(4) VARCHAR2(4) NOT NULL Term
    5 CLASS_NBR Number(5,0) INTEGER NOT NULL Class Nbr
    6 SEQ_3C Number(5,0) INTEGER NOT NULL Sequence Number
    7 COMM_CATEGORY Character(6) VARCHAR2(6) NOT NULL Communication Category
    8 SCC_LETTER_CD Character(3) VARCHAR2(3) NOT NULL Letter Code
    9 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    10 COMPLETED_DT Date(10) DATE Date Activity Completed
    11 COMPLETED_COMM Character(1) VARCHAR2(1) NOT NULL Communication Completed
    12 UNSUCCESSFUL Character(1) VARCHAR2(1) NOT NULL Unsuccessful Outcome
    13 OUTCOME_REASON Character(1) VARCHAR2(1) NOT NULL Outcome Reason
    C=Missing Critical Data
    E=Invalid Email Address
    M=Left Message on Machine
    N=No Answer
    O=No Org Recipients found
    P=Left Message with Person
    R=Returned Mail
    S=Email Send Error
    14 COMM_ID Character(11) VARCHAR2(11) NOT NULL Person responsible for the communication
    15 COMPLETED_ID Character(11) VARCHAR2(11) NOT NULL Completed ID
    16 COMM_DT Date(10) DATE Communication Date
    17 COMM_DTTM DateTime(26) TIMESTAMP Communication DateTime