RUN_CNTL_ADFNL

(SQL Table)
 Index Back

Adm Funnel Rpt Run Control

RUN_CNTL_ADFNL contains fields that are used as input parameters for the Admissions Funnel Report. Input data is retrieved from this record when a report is requested from the Process Scheduler.

  • Parent Record Of RUN_CNTL_ADFNL1 RUN_CNTL_ADFNL2

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
    3 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

    4 ADFUNNEL_RPT_TYPE Character(4) VARCHAR2(4) NOT NULL Admissions Funnel Report Type
    E=Also By Ethnicity
    G=Also By Gender
    M=Also By Appl. Method
    N=Only By App. Type, Status
    P=Also By Program
    R=Also By Region
    S=Also By Country/State
    V=Also By Event Type

    Default Value: N

    5 ADF_COMPARE Character(1) VARCHAR2(1) NOT NULL Create Compare Report

    Y/N Table Edit

    Default Value: N

    6 ADF_DETAIL Character(1) VARCHAR2(1) NOT NULL Show Term Detail

    Y/N Table Edit

    Default Value: N

    7 ADF_ACAD_YEAR1 Character(4) VARCHAR2(4) NOT NULL All Terms for Academic Year

    Prompt Table: TERM_YR1_VW

    8 ADF_ACAD_YEAR2 Character(4) VARCHAR2(4) NOT NULL All Terms in Comparison Year

    Prompt Table: TERM_YR2_VW

    9 ADDRESS_TYPE Character(4) VARCHAR2(4) NOT NULL Address Type

    Prompt Table: HCR_ADDR_TYP_I

    10 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region

    Prompt Table: REG_REGION_TBL