ORG_COMMENT

(SQL Table)
 Index Back

Organization Comment

ORG_COMMENT is used to record free-form comments made about an organization. These comments may be shared or restricted based on user-defined Inquiry Groups.

  • 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 COMMENT_DTTM DateTime(26) TIMESTAMP NOT NULL Comment DateTime

    Default Value: %date

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

    Prompt Table: ADM_FCN_ORG_VW

    4 CMNT_CATEGORY Character(6) VARCHAR2(6) NOT NULL Comment Category

    Prompt Table: CMNT_CATG_VW

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

    Default Value: OPR_DEF_TBL_CS.DEPTID

    Prompt Table: DEPT_TBL

    6 CMNT_ID Character(11) VARCHAR2(11) NOT NULL Comment ID

    Prompt Table: PEOPLE_SRCH

    7 COMMENT_DT Date(10) DATE Comment Date

    Default Value: %date

    8 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

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

    Prompt Table: %EDITTABLE11

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

    Prompt Table: ACAD_PROG_TBL

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

    Prompt Table: ACAD_PLAN

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

    Prompt Table: %EDITTABLE10

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

    Prompt Table: STUDENT_AID

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

    Prompt Table: CAMPUS_EVENT_VW

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

    Prompt Table: EVENT_MTG

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

    Prompt Table: APPL_NBR_DVW

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

    Prompt Table: BUS_UNIT_TBL_SF

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

    Prompt Table: CSH_OFF_TBL

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

    Prompt Table: %EDITTABLE9

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

    Prompt Table: TP_CONTRACT

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

    Prompt Table: GROUP_CONT_INFO

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

    Prompt Table: %EDITTABLE3

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

    Prompt Table: %EDITTABLE7

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

    Prompt Table: %EDITTABLE8

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

    Prompt Table: %EDITTABLE4

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

    Prompt Table: %EDITTABLE5

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

    Prompt Table: %EDITTABLE6

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

    Prompt Table: ADM_APPL_PROG

    29 EFFDT_VAR Date(10) DATE Effective Date
    30 EFFSEQ_VAR Number(1,0) SMALLINT NOT NULL Effective Date Sequence #
    31 ITEM_TYPE Character(12) VARCHAR2(12) NOT NULL Item Type

    Prompt Table: %EDITTABLE13

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

    Prompt Table: %EDITTABLE

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

    Prompt Table: %EDITTABLE2

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

    Prompt Table: LN_TYPE_TBL

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

    Prompt Table: STDNT_RSTRC_AID

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

    Prompt Table: AV_RCG_DES_VW1

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

    Prompt Table: AV_RCG_DES_VW2

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

    Prompt Table: AV_RCG_DES_VW3

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

    Prompt Table: AV_RCG_DES_VW5

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

    Prompt Table: %EDITTABLE12

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

    Prompt Table: AV_INITIATE_VW1

    44 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
    45 MEMBERSHIP_NBR Character(12) VARCHAR2(12) NOT NULL Membership Number

    Prompt Table: AV_MEMBER_VW1

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

    Prompt Table: AV_MEMBER_VW2

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

    Prompt Table: AV_MBR_BNFT_VW2

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

    Prompt Table: AV_MBR_BNFT_VW1

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

    Prompt Table: SSF_IHC_STDPAR

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

    Prompt Table: SAD_BPV_COMM_VW

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

    Prompt Table: SAD_OWO_COMM_VW

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

    Prompt Table: SAD_PB_CASNBRVW

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

    Prompt Table: SSR_RS_CANDIDVW

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

    Prompt Table: SSR_RS_CNDNBRVW

    56 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

    57 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

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

    Prompt Table: SSR_RS_SUPNBRVW

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

    Prompt Table: SSR_RS_OTRQTYVW

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

    Prompt Table: STDNT_ENRL_L_VW

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

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

    62 COMMENTS Long Character CLOB Comment