SAD_COMM_VW_NLD

(SQL View)
 Index Back

3C Communication View NLD


SELECT A.COMMON_ID ,A.SEQ_3C ,A.SA_ID_TYPE ,A.COMM_DTTM ,A.INSTITUTION ,A.ADMIN_FUNCTION ,A.COMM_CATEGORY ,A.COMM_CONTEXT ,A.COMM_METHOD ,A.INCLUDE_ENCL ,A.DEPTID ,A.COMM_ID ,A.COMM_DT ,A.COMM_BEGIN_TM ,A.COMM_END_TM ,A.COMPLETED_COMM ,A.COMPLETED_ID ,A.COMPLETED_DT ,A.COMM_DIRECTION ,A.UNSUCCESSFUL ,A.OUTCOME_REASON ,A.SCC_LETTER_CD ,A.LETTER_PRINTED_DT ,A.LETTER_PRINTED_TM ,A.CHECKLIST_SEQ_3C ,A.CHECKLIST_SEQ ,A.COMMENT_PRINT_FLAG ,A.ORG_CONTACT ,A.ORG_DEPARTMENT ,A.ORG_LOCATION ,A.PROCESS_INSTANCE ,A.EXT_ORG_ID ,A.VAR_DATA_SEQ ,A.COMM_COMMENTS ,A.EMPLID_RELATED ,A.JOINT_COMM ,B.SAD_INT_CONTR_NLD FROM PS_COMMUNICATION A , PS_VAR_DATA_NLBP B WHERE B.COMMON_ID = A.COMMON_ID AND B.VAR_DATA_SEQ = A.VAR_DATA_SEQ AND A.ADMIN_FUNCTION = 'NLBP'

  • Parent record: VAR_DATA_NLBP

    • # 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 SEQ_3C Number(5,0) INTEGER NOT NULL Sequence Number

    Default Value: 99999

    3 SA_ID_TYPE Character(1) VARCHAR2(1) NOT NULL ID Type
    O=Organization
    P=Person
    4 COMM_DTTM DateTime(26) TIMESTAMP NOT NULL Communication DateTime

    Default Value: %datetime

    5 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

    6 ADMIN_FUNCTION Character(4) VARCHAR2(4) NOT NULL Administrative Function

    Prompt Table: %EDITTABLE15

    7 COMM_CATEGORY Character(6) VARCHAR2(6) NOT NULL Communication Category

    Prompt Table: COMM_CATG_VW

    8 COMM_CONTEXT Character(6) VARCHAR2(6) NOT NULL Communication Context

    Prompt Table: COMM_CA_CTX_VW

    9 COMM_METHOD Character(1) VARCHAR2(1) NOT NULL Communication Method
    B=Publication
    D=Document
    E=Email
    F=Fax
    L=Letter
    P=Personal Contact
    T=Telephone Call
    W=Web

    Prompt Table: COMM_CTX_ME_VW2

    10 INCLUDE_ENCL Character(1) VARCHAR2(1) NOT NULL Include Enclosures

    Y/N Table Edit

    Default Value: N

    11 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Default Value: OPR_DEF_TBL_CS.DEPTID

    Prompt Table: DEPT_TBL_ACCESS
    Set Control Field: INSTITUTION

    12 COMM_ID Character(11) VARCHAR2(11) NOT NULL Person responsible for the communication

    Prompt Table: PEOPLE_SRCH

    13 COMM_DT Date(10) DATE Communication Date

    Default Value: %date

    14 COMM_BEGIN_TM Time(15) TIMESTAMP Communication Begin Time
    15 COMM_END_TM Time(15) TIMESTAMP Communication End Time
    16 COMPLETED_COMM Character(1) VARCHAR2(1) NOT NULL Communication Completed

    Y/N Table Edit

    Default Value: N

    17 COMPLETED_ID Character(11) VARCHAR2(11) NOT NULL Completed ID

    Prompt Table: PEOPLE_SRCH

    18 COMPLETED_DT Date(10) DATE Date Activity Completed
    19 COMM_DIRECTION Character(4) VARCHAR2(4) NOT NULL Communication Direction
    IN=Incoming Communication
    OUT=Outgoing Communication
    PERS=In Person

    Prompt Table: COMM_ME_DIR_VW

    20 UNSUCCESSFUL Character(1) VARCHAR2(1) NOT NULL Unsuccessful Outcome

    Y/N Table Edit

    Default Value: N

    21 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
    22 SCC_LETTER_CD Character(3) VARCHAR2(3) NOT NULL Letter Code

    Prompt Table: COMM_CTX_ME_VW

    23 LETTER_PRINTED_DT Date(10) DATE Date letter was printed
    24 LETTER_PRINTED_TM Time(15) TIMESTAMP Time Letter Printed
    25 CHECKLIST_SEQ_3C Number(5,0) INTEGER NOT NULL Checklist Seq Number
    26 CHECKLIST_SEQ Number(6,0) INTEGER NOT NULL Checklist Sequence
    27 COMMENT_PRINT_FLAG Character(1) VARCHAR2(1) NOT NULL Print Comments for Communications

    Y/N Table Edit

    Default Value: N

    28 ORG_CONTACT Number(4,0) SMALLINT NOT NULL Contact Nbr

    Prompt Table: ORG_CONTACT3_VW

    29 ORG_DEPARTMENT Number(3,0) SMALLINT NOT NULL Department Nbr

    Prompt Table: ORG_DEPT_VW

    30 ORG_LOCATION Number(3,0) SMALLINT NOT NULL Location Nbr

    Prompt Table: ORG_LOCATIONVW2

    31 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    32 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID
    33 VAR_DATA_SEQ Number(4,0) SMALLINT NOT NULL Variable Data Sequence Number
    34 COMM_COMMENTS Long Character(2000) VARCHAR2(2000) Communication Comments
    35 EMPLID_RELATED Character(11) VARCHAR2(11) NOT NULL Related People ID
    36 JOINT_COMM Character(1) VARCHAR2(1) NOT NULL Create Joint Communications

    Y/N Table Edit

    Default Value: N

    37 SAD_INT_CONTR_NLD Character(16) VARCHAR2(16) NOT NULL Internal contract