ORG_CHECKLIST

(SQL Table)
 Index Back

Organization Checklist

ORG_CHECKLST is used to create a list of requirements, communication, staff assignments, etc. relative to an organization. There is one record in this table for each dated list.

  • 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 CHECKLIST_DTTM DateTime(26) TIMESTAMP NOT NULL Checklist Date Time

    Default Value: %date

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

    Prompt Table: ADM_FCN_ORG_VW

    4 CHECKLIST_CD Character(6) VARCHAR2(6) NOT NULL Checklist Code

    Prompt Table: CHKLST_SCTY_VW

    5 CHECKLIST_STATUS Character(1) VARCHAR2(1) NOT NULL Checklist Status
    C=Completed
    I=Initiated

    Default Value: I

    6 STATUS_DT Date(10) DATE Status Date

    Default Value: %date

    7 STATUS_CHANGE_ID Character(11) VARCHAR2(11) NOT NULL Status Change ID

    Prompt Table: PEOPLE_SRCH

    8 DUE_DT Date(10) DATE Due Date
    9 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    10 DUE_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Due Amount
    11 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Default Value: OPR_DEF_TBL_CS.DEPTID

    Prompt Table: DEPT_TBL

    12 RESPONSIBLE_ID Character(11) VARCHAR2(11) NOT NULL Responsible ID

    Default Value: ORG_CHECKLIST.STATUS_CHANGE_ID

    Prompt Table: PEOPLE_SRCH

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

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

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

    Prompt Table: ORG_CONTACT

    15 CONTACT_NAME Character(50) VARCHAR2(50) NOT NULL Contact Name
    16 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

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

    Prompt Table: %EDITTABLE11

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

    Prompt Table: ACAD_PROG_TBL

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

    Prompt Table: ACAD_PLAN

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

    Prompt Table: %EDITTABLE10

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

    Prompt Table: STUDENT_AID

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

    Prompt Table: CAMPUS_EVENT_VW

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

    Prompt Table: EVENT_MTG

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

    Prompt Table: APPL_NBR_DVW

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

    Prompt Table: BUS_UNIT_TBL_SF

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

    Prompt Table: CSH_OFF_TBL

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

    Prompt Table: %EDITTABLE9

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

    Prompt Table: TP_CONTRACT

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

    Prompt Table: GROUP_CONT_INFO

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

    Prompt Table: %EDITTABLE3

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

    Prompt Table: %EDITTABLE7

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

    Prompt Table: %EDITTABLE8

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

    Prompt Table: %EDITTABLE4

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

    Prompt Table: %EDITTABLE5

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

    Prompt Table: %EDITTABLE6

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

    Prompt Table: ADM_APPL_PROG

    37 EFFDT_VAR Date(10) DATE Effective Date
    38 EFFSEQ_VAR Number(1,0) SMALLINT NOT NULL Effective Date Sequence #
    39 ITEM_TYPE Character(12) VARCHAR2(12) NOT NULL Item Type

    Prompt Table: %EDITTABLE13

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

    Prompt Table: %EDITTABLE

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

    Prompt Table: %EDITTABLE2

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

    Prompt Table: LN_TYPE_TBL

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

    Prompt Table: STDNT_RSTRC_AID

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

    Prompt Table: AV_RCG_DES_VW1

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

    Prompt Table: AV_RCG_DES_VW2

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

    Prompt Table: AV_RCG_DES_VW3

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

    Prompt Table: AV_RCG_DES_VW5

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

    Prompt Table: %EDITTABLE12

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

    Prompt Table: AV_INITIATE_VW1

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

    Prompt Table: AV_MEMBER_VW1

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

    Prompt Table: AV_MEMBER_VW2

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

    Prompt Table: AV_MBR_BNFT_VW2

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

    Prompt Table: AV_MBR_BNFT_VW1

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

    Prompt Table: SSF_IHC_STDPAR

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

    Prompt Table: SAD_BPV_COMM_VW

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

    Prompt Table: SAD_OWO_COMM_VW

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

    Prompt Table: SAD_PB_CASNBRVW

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

    Prompt Table: SSR_RS_CANDIDVW

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

    Prompt Table: SSR_RS_CNDNBRVW

    64 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

    65 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

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

    Prompt Table: SSR_RS_SUPNBRVW

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

    Prompt Table: SSR_RS_OTRQTYVW

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

    Prompt Table: STDNT_ENRL_L_VW

    69 TRACKING_SEQ Number(3,0) SMALLINT NOT NULL Tracking Sequence
    70 COMM_COMMENTS Long Character(2000) VARCHAR2(2000) Communication Comments