ORG_COMM

(SQL Table)
 Index Back

Organizatn Communication Data

ORG_COMM is used to record all incoming/outgoing/in contact that an institution has with an organization.

  • Parent record: EXT_ORG_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID

    Prompt Table: EXT_ORG_TBL

    2 COMM_DTTM DateTime(26) TIMESTAMP NOT NULL Communication DateTime

    Default Value: %date

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

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

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

    Prompt Table: ADM_FCN_ORG_VW

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

    Prompt Table: COMM_CATG_VW

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

    Prompt Table: COMM_CA_CTX_VW

    7 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_TBL

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

    Default Value: OPR_DEF_TBL_CS.DEPTID

    Prompt Table: DEPT_TBL

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

    Prompt Table: PEOPLE_SRCH

    10 COMM_DT Date(10) DATE Communication Date

    Default Value: %date

    11 COMM_BEGIN_TM Time(15) TIMESTAMP Communication Begin Time

    Default Value: %date

    12 COMM_END_TM Time(15) TIMESTAMP Communication End Time

    Default Value: %date

    13 COMPLETED_COMM Character(1) VARCHAR2(1) NOT NULL Communication Completed

    Y/N Table Edit

    Default Value: N

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

    Prompt Table: PEOPLE_SRCH

    15 COMPLETED_DT Date(10) DATE Date Activity Completed
    16 COMM_DIRECTION Character(4) VARCHAR2(4) NOT NULL Communication Direction
    IN=Incoming Communication
    OUT=Outgoing Communication
    PERS=In Person
    17 UNSUCCESSFUL Character(1) VARCHAR2(1) NOT NULL Unsuccessful Outcome

    Y/N Table Edit

    Default Value: N

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

    Prompt Table: COMM_CTX_ME_VW

    20 LETTER_PRINTED_DT Date(10) DATE Date letter was printed
    21 LETTER_PRINTED_TM Time(15) TIMESTAMP Time Letter Printed
    22 CHECKLIST_DTTM DateTime(26) TIMESTAMP Checklist Date Time
    23 CHECKLIST_SEQ Number(6,0) INTEGER NOT NULL Checklist Sequence

    Prompt Table: ORG_CHK_ITEM

    24 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

    Prompt Table: %EDITTABLE14

    25 STDNT_CAR_NBR Number(3,0) SMALLINT NOT NULL Student Career Nbr

    Prompt Table: %EDITTABLE11

    26 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program

    Prompt Table: ACAD_PROG_TBL

    27 ACAD_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Plan

    Prompt Table: ACAD_PLAN

    28 STRM Character(4) VARCHAR2(4) NOT NULL Term

    Prompt Table: %EDITTABLE10

    29 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year

    Prompt Table: STUDENT_AID

    30 CAMPUS_EVENT_NBR Character(9) VARCHAR2(9) NOT NULL Event ID

    Prompt Table: CAMPUS_EVENT_VW

    31 EVENT_MTG_NBR Number(4,0) SMALLINT NOT NULL Event Meeting Nbr

    Prompt Table: EVENT_MTG

    32 ADM_APPL_NBR Character(8) VARCHAR2(8) NOT NULL Application Nbr

    Prompt Table: APPL_NBR_DVW

    33 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: BUS_UNIT_TBL_SF

    34 CASHIER_OFFICE Character(8) VARCHAR2(8) NOT NULL Cashier's Office

    Prompt Table: CSH_OFF_TBL

    35 COLLECTION_ID Number(12,0) DECIMAL(12) NOT NULL Collection ID

    Prompt Table: %EDITTABLE9

    36 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract Number

    Prompt Table: TP_CONTRACT

    37 GROUP_ID_SF Character(15) VARCHAR2(15) NOT NULL Group ID

    Prompt Table: GROUP_CONT_INFO

    38 INVOICE_ID Character(22) VARCHAR2(22) NOT NULL Invoice Number

    Prompt Table: %EDITTABLE3

    39 ITEM_NBR Character(15) VARCHAR2(15) NOT NULL Item Nbr

    Prompt Table: %EDITTABLE7

    40 LINE_SEQ_NBR Number(3,0) SMALLINT NOT NULL Line Sequence Nbr

    Prompt Table: %EDITTABLE8

    41 PAYMENT_ID_NBR Number(12,0) DECIMAL(12) NOT NULL Payment ID Nbr

    Prompt Table: %EDITTABLE4

    42 RECEIPT_NBR Number(12,0) DECIMAL(12) NOT NULL Receipt Number

    Prompt Table: %EDITTABLE5

    43 REFUND_NBR Number(12,0) DECIMAL(12) NOT NULL Refund Nbr

    Prompt Table: %EDITTABLE6

    44 APPL_PROG_NBR Number(3,0) SMALLINT NOT NULL Application Program Nbr

    Prompt Table: ADM_APPL_PROG

    45 EFFDT_VAR Date(10) DATE Effective Date
    46 EFFSEQ_VAR Number(1,0) SMALLINT NOT NULL Effective Date Sequence #
    47 ITEM_TYPE Character(12) VARCHAR2(12) NOT NULL Item Type

    Prompt Table: %EDITTABLE13

    48 ACCOUNT_NBR Character(10) VARCHAR2(10) NOT NULL Account Nbr

    Prompt Table: %EDITTABLE

    49 ACCOUNT_TERM Character(4) VARCHAR2(4) NOT NULL Account Term

    Prompt Table: %EDITTABLE2

    50 CHECKLIST_DTTM_VAR DateTime(26) TIMESTAMP Checklist Date Time
    51 LOAN_TYPE Character(4) VARCHAR2(4) NOT NULL Loan Type Cd

    Prompt Table: LN_TYPE_TBL

    52 LN_APPL_SEQ Number(2,0) SMALLINT NOT NULL Loan Application Seq Num
    53 RESTRICTED_AID_ID Character(10) VARCHAR2(10) NOT NULL Restricted Aid ID

    Prompt Table: STDNT_RSTRC_AID

    54 SESSION_NO Character(11) VARCHAR2(11) NOT NULL Session Nbr

    Prompt Table: AV_RCG_DES_VW1

    55 GIFT_NO Character(11) VARCHAR2(11) NOT NULL Gift Nbr

    Prompt Table: AV_RCG_DES_VW2

    56 RECOGNITION_TYPE Character(1) VARCHAR2(1) NOT NULL Recognition Type

    Prompt Table: AV_RCG_DES_VW3

    57 DESIGNATION Character(11) VARCHAR2(11) NOT NULL Designation

    Prompt Table: AV_RCG_DES_VW5

    58 INTV_CD Character(10) VARCHAR2(10) NOT NULL Initiative Code

    Prompt Table: %EDITTABLE12

    59 AV_AUDIENCE Character(10) VARCHAR2(10) NOT NULL Audience Code

    Prompt Table: AV_INITIATE_VW1

    60 AUD_TYPE Character(1) VARCHAR2(1) NOT NULL Indicates whether the population is being identified for Segmentation, Reporting, or Administration.
    A=Administrative
    R=Reporting
    S=Segmentation
    61 MEMBERSHIP_NBR Character(12) VARCHAR2(12) NOT NULL Membership Number

    Prompt Table: AV_MEMBER_VW1

    62 AV_MBR_ORG_COD Character(10) VARCHAR2(10) NOT NULL Member Organization Code

    Prompt Table: AV_MEMBER_VW2

    63 AV_STD_BEN Character(6) VARCHAR2(6) NOT NULL Standard Benefit

    Prompt Table: AV_MBR_BNFT_VW2

    64 MBR_PMT_NO Character(11) VARCHAR2(11) NOT NULL Member Payment Number

    Prompt Table: AV_MBR_BNFT_VW1

    65 LN_APPL_ID Character(21) VARCHAR2(21) NOT NULL Loan Application ID
    66 SSF_IHC_COVER_NBR Number(3,0) SMALLINT NOT NULL Coverage Number

    Prompt Table: SSF_IHC_STDPAR

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

    Prompt Table: SAD_BPV_COMM_VW

    68 SAD_CONTRACTNR_NLD Number(12,0) DECIMAL(12) NOT NULL Unique OWO contract number.

    Prompt Table: SAD_OWO_COMM_VW

    69 SAD_PB_CAS_NUMBER Character(14) VARCHAR2(14) NOT NULL CAS Number

    Prompt Table: SAD_PB_CASNBRVW

    70 SSR_RS_CANDIT_ID Character(11) VARCHAR2(11) NOT NULL Candidate EMPLID

    Prompt Table: SSR_RS_CANDIDVW

    71 SSR_RS_CANDIT_NBR Character(12) VARCHAR2(12) NOT NULL Last Candidate Number

    Prompt Table: SSR_RS_CNDNBRVW

    72 SSR_RS_SUBMSSN_NBR Number(3,0) SMALLINT NOT NULL This field indicates the number of times the thesis has been resubmitted for examination

    Prompt Table: SSR_RS_SBMNBRVW

    73 SSR_RS_TOPIC_SEQ Number(3,0) SMALLINT NOT NULL This field is used to create a unique key when multiple topics exist for a research project.

    Prompt Table: SSR_RS_TOPSEQVW

    74 SSR_RS_SUPER_NBR Number(3,0) SMALLINT NOT NULL Last Candidate Number

    Prompt Table: SSR_RS_SUPNBRVW

    75 SSR_RS_RQUIRE_TYPE Character(2) VARCHAR2(2) NOT NULL Field to hold Research Assignment Types

    Prompt Table: SSR_RS_OTRQTYVW

    76 CLASS_NBR Number(5,0) INTEGER NOT NULL Class Nbr

    Prompt Table: STDNT_ENRL_L_VW

    77 COMMENT_PRINT_FLAG Character(1) VARCHAR2(1) NOT NULL Print Comments for Communications

    Y/N Table Edit

    Default Value: N

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

    Prompt Table: ORG_CONTACT

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

    Prompt Table: ORG_DEPT

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

    Prompt Table: ORG_LOCATION

    81 COMM_COMMENTS Long Character(2000) VARCHAR2(2000) Communication Comments