CA_SPNSR_UPL_RQ

(SQL Table)
 Index Back

File Upload Run Control

Sponsor file upload process run control record.

  • Related Language Record: CA_SPNSR_U_LANG

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

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    4 SPONSOR_ID Character(15) VARCHAR2(15) NOT NULL SPONSOR_ID

    Prompt Table: CA_SPNSR_VW

    5 LOC_REFERENCE_ID Character(10) VARCHAR2(10) NOT NULL Letter of Credit ID

    Prompt Table: GM_SPNSR_LC2_VW

    6 FILE_SEL_OPTN Character(1) VARCHAR2(1) NOT NULL File Selection Option.
    A=Using File Attachment
    P=Using File Path

    Default Value: A

    7 FILE_PATH_NAME Character(254) VARCHAR2(254) NOT NULL File Path
    8 SPNSR_FILENAME Character(50) VARCHAR2(50) NOT NULL Contracts Sponsor Upload File Name
    9 FILENAME_OVERRIDE Character(50) VARCHAR2(50) NOT NULL Filename Override
    10 LOC_ATTACHUSERFILE Character(50) VARCHAR2(50) NOT NULL Attach Sponsor LOC file
    11 ARCHIVED_DIR Character(124) VARCHAR2(124) NOT NULL Directory details to contain archived Files.