SSF_IHC_RUNCTL

(SQL Table)
 Index Back

Run Control IHC

This table stores the parameters used in running the International Student Health Coverage Schedules, SFIHCSCH.SQR.

  • Parent record: PRCSRUNCNTL

    • # 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 SSF_IHC_PROVIDER Character(8) VARCHAR2(8) NOT NULL Provider ID

    Prompt Table: SSF_IHC_PROVIDR

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

    Prompt Table: INSTITUTION_TBL

    5 SSF_IHC_RFND_SCHED Character(1) VARCHAR2(1) NOT NULL IHC Refund Schedule

    Y/N Table Edit

    Default Value: N

    6 SSF_IHC_OUTPUT Character(1) VARCHAR2(1) NOT NULL Schedule Output Type
    B=Both Paper and CSV File
    C=CSV File
    P=Paper

    Default Value: C

    7 FILE_PATH Character(127) VARCHAR2(127) NOT NULL Input/Output file path
    8 SSF_IHC_RPT_AMTTYP Character(1) VARCHAR2(1) NOT NULL Report Amount Type
    D=Report Difference
    F=Report Full Amount

    Default Value: D

    9 SSF_IHC_RCRT_SCHED Character(1) VARCHAR2(1) NOT NULL Re-create Schedule?

    Y/N Table Edit

    Default Value: N

    10 SSF_IHC_RPT_NBR Character(12) VARCHAR2(12) NOT NULL Report Number

    Prompt Table: SSF_IHC_RPTNBVW
    Set Control Field: SSF_IHC_RPT_NBR

    11 SSF_IHC_RUN_DATE Date(10) DATE Run Date

    Prompt Table: SSF_IHC_RPTDTVW

    12 SSF_IHC_REPRT_CRIT Character(1) VARCHAR2(1) NOT NULL Recreate Schedule Using
    D=Run Date
    R=Report Number

    Default Value: R