ADM_FUNCTN_TBL

(SQL Table)
 Index Back

Administrative Function Table

The ADM_FUNCTN_TBL stores the codes for the core functional areas in Student Administration that process Communication, Checklists, and Comments. It also stores the key data that should be populated as variable data on the Communication, Checklist, and Comments records. This key data is flagged on the ADM_FUNCTN_TBL and used to hide and unhide fields on the appropriate panels.

  • Related Language Record: ADM_FUNCTN_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ADMIN_FUNCTION Character(4) VARCHAR2(4) NOT NULL Administrative Function
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: ADM_FUNCTN_TBL.DESCR

    6 ACAD_CAREER_AF Character(1) VARCHAR2(1) NOT NULL Acad Career

    Y/N Table Edit

    Default Value: N

    7 STDNT_CAR_NBR_AF Character(1) VARCHAR2(1) NOT NULL Student Career Nbr

    Y/N Table Edit

    Default Value: N

    8 ACAD_PROG_AF Character(1) VARCHAR2(1) NOT NULL Academic Program

    Y/N Table Edit

    Default Value: N

    9 ACAD_PLAN_AF Character(1) VARCHAR2(1) NOT NULL Academic Plan

    Y/N Table Edit

    Default Value: N

    10 STRM_AF Character(1) VARCHAR2(1) NOT NULL Term

    Y/N Table Edit

    Default Value: N

    11 AID_YEAR_AF Character(1) VARCHAR2(1) NOT NULL Aid Year

    Y/N Table Edit

    Default Value: N

    12 CAMPUS_EVNT_NBR_AF Character(1) VARCHAR2(1) NOT NULL Event ID

    Y/N Table Edit

    Default Value: N

    13 EVENT_MTG_NBR_AF Character(1) VARCHAR2(1) NOT NULL Event Meeting Nbr

    Y/N Table Edit

    Default Value: N

    14 ADM_APPL_NBR_AF Character(1) VARCHAR2(1) NOT NULL Application Nbr

    Y/N Table Edit

    Default Value: N

    15 BUSINESS_UNIT_AF Character(1) VARCHAR2(1) NOT NULL Business Unit

    Y/N Table Edit

    Default Value: N

    16 ACCOUNT_NBR_AF Character(1) VARCHAR2(1) NOT NULL Account Number

    Y/N Table Edit

    Default Value: N

    17 APPL_PROG_NBR_AF Character(1) VARCHAR2(1) NOT NULL Application Program Nbr

    Y/N Table Edit

    Default Value: N

    18 EFFDT_AF Character(1) VARCHAR2(1) NOT NULL Effective Date

    Y/N Table Edit

    Default Value: N

    19 EFFSEQ_AF Character(1) VARCHAR2(1) NOT NULL Effective Date Sequence #

    Y/N Table Edit

    Default Value: N

    20 ITEM_TYPE_AF Character(1) VARCHAR2(1) NOT NULL Item Type

    Y/N Table Edit

    Default Value: N

    21 CASHIER_OFFICE_AF Character(1) VARCHAR2(1) NOT NULL Cashier's Office

    Y/N Table Edit

    Default Value: N

    22 CHECKLIST_DTTM_AF Character(1) VARCHAR2(1) NOT NULL Checklist DateTime

    Y/N Table Edit

    Default Value: N

    23 COLLECTION_ID_AF Character(1) VARCHAR2(1) NOT NULL Collection ID

    Y/N Table Edit

    Default Value: N

    24 CONTRACT_NUM_AF Character(1) VARCHAR2(1) NOT NULL Contract Nbr

    Y/N Table Edit

    Default Value: N

    25 GROUP_ID_SF_AF Character(1) VARCHAR2(1) NOT NULL Group ID

    Y/N Table Edit

    Default Value: N

    26 INVOICE_ID_AF Character(1) VARCHAR2(1) NOT NULL Invoice ID

    Y/N Table Edit

    Default Value: N

    27 ITEM_NBR_AF Character(1) VARCHAR2(1) NOT NULL Item Nbr

    Y/N Table Edit

    Default Value: N

    28 LINE_SEQ_NBR_AF Character(1) VARCHAR2(1) NOT NULL Line Sequence Nbr

    Y/N Table Edit

    Default Value: N

    29 PAYMENT_ID_NBR_AF Character(1) VARCHAR2(1) NOT NULL Payment ID Nbr

    Y/N Table Edit

    Default Value: N

    30 RECEIPT_NBR_AF Character(1) VARCHAR2(1) NOT NULL Receipt Number

    Y/N Table Edit

    Default Value: N

    31 REFUND_NBR_AF Character(1) VARCHAR2(1) NOT NULL Refund Nbr

    Y/N Table Edit

    Default Value: N

    32 ACCOUNT_TERM_AF Character(1) VARCHAR2(1) NOT NULL Account Term

    Y/N Table Edit

    Default Value: N

    33 LN_APPL_SEQ_AF Character(1) VARCHAR2(1) NOT NULL Loan Application Seq Nbr

    Y/N Table Edit

    Default Value: N

    34 LOAN_TYPE_AF Character(1) VARCHAR2(1) NOT NULL Loan Type Cd

    Y/N Table Edit

    Default Value: N

    35 RSTRCT_AID_ID_AF Character(1) VARCHAR2(1) NOT NULL Restricted Aid ID

    Y/N Table Edit

    Default Value: N

    36 AUD_TYPE_AF Character(1) VARCHAR2(1) NOT NULL Indicates whether the population is being identified for Segmentation, Reporting, or Administration.

    Y/N Table Edit

    Default Value: N

    37 AV_AUDIENCE_AF Character(1) VARCHAR2(1) NOT NULL Audience Code

    Y/N Table Edit

    Default Value: N

    38 AV_MBR_ORG_COD_AF Character(1) VARCHAR2(1) NOT NULL Member Organization Code

    Y/N Table Edit

    Default Value: N

    39 AV_STD_BEN_AF Character(1) VARCHAR2(1) NOT NULL Standard Benefit

    Y/N Table Edit

    Default Value: N

    40 DESIGNATION_AF Character(1) VARCHAR2(1) NOT NULL Designation Code

    Y/N Table Edit

    Default Value: N

    41 GIFT_NO_AF Character(1) VARCHAR2(1) NOT NULL Gift Nbr

    Y/N Table Edit

    Default Value: N

    42 INTV_CD_AF Character(1) VARCHAR2(1) NOT NULL Initiative Code

    Y/N Table Edit

    Default Value: N

    43 MBR_PMT_NO_AF Character(1) VARCHAR2(1) NOT NULL Member Payment Number

    Y/N Table Edit

    Default Value: N

    44 MEMBERSHIP_NBR_AF Character(1) VARCHAR2(1) NOT NULL Membership Number

    Y/N Table Edit

    Default Value: N

    45 RECOGNITION_TYP_AF Character(1) VARCHAR2(1) NOT NULL Recognition Type

    Y/N Table Edit

    Default Value: N

    46 SESSION_NO_AF Character(1) VARCHAR2(1) NOT NULL Session Nbr

    Y/N Table Edit

    Default Value: N

    47 SUB_FNCTN_USED Character(1) VARCHAR2(1) NOT NULL Sub-Function(s) Used

    Y/N Table Edit

    Default Value: N

    48 ADMIN_FCN_PEOPLE Character(1) VARCHAR2(1) NOT NULL Admin Function - People

    Y/N Table Edit

    Default Value: Y

    49 ADMIN_FCN_ORG Character(1) VARCHAR2(1) NOT NULL Admin Function - Organizations

    Y/N Table Edit

    Default Value: N

    50 SAD_CONTRACTNR_AF Character(1) VARCHAR2(1) NOT NULL Contract Number (NLD)

    Y/N Table Edit

    51 SSF_IHC_COV_NBR_AF Character(1) VARCHAR2(1) NOT NULL Coverage Number

    Y/N Table Edit

    Default Value: N

    52 SAD_INT_CONTR_AF Character(1) VARCHAR2(1) NOT NULL Netherlands field. SAD_INT_CONTR_NLD

    Y/N Table Edit

    53 SAD_PB_CASN_AF Character(1) VARCHAR2(1) NOT NULL CAS Number

    Y/N Table Edit

    Default Value: N

    54 SSR_RS_CANDID_AF Character(1) VARCHAR2(1) NOT NULL Candidate EMPLID

    Y/N Table Edit

    Default Value: N

    55 SSR_RS_CANDNBR_AF Character(1) VARCHAR2(1) NOT NULL Candidate Number

    Y/N Table Edit

    Default Value: N

    56 SSR_RS_SUBMNBR_AF Character(1) VARCHAR2(1) NOT NULL Submission Number

    Y/N Table Edit

    Default Value: N

    57 SSR_RS_TOPICSEQ_AF Character(1) VARCHAR2(1) NOT NULL Topic Sequence

    Y/N Table Edit

    Default Value: N

    58 SSR_RS_SUPRVSEQ_AF Character(1) VARCHAR2(1) NOT NULL Supervisor Sequence

    Y/N Table Edit

    Default Value: N

    59 SSR_RS_REQTYPE_AF Character(1) VARCHAR2(1) NOT NULL Requirement Type

    Y/N Table Edit

    Default Value: N

    60 SSR_CLASS_NBR_AF Character(1) VARCHAR2(1) NOT NULL This field is used as a Y/N flag for identifying fields needed for administrative functions.

    Y/N Table Edit

    Default Value: N