ADDN_PARS_REQ

(SQL Table)
Index Back

Addenda Parsing Request

Addenda Parsing Run Control Record.

  • 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).

    Default Value: OPRID_VW.OPRID

    Prompt Table: OPRID_VW

    2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

    Prompt Table: RECON_REQUEST_V

    3 REQUEST_NBR Number(4,0) SMALLINT NOT NULL Request Number

    Default Value: 9999

    4 BNK_ID_NBR Character(20) VARCHAR2(20) NOT NULL A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.

    Prompt Table: BANK_ID_DVW3

    5 BANK_ACCOUNT_NUM Character(35) VARCHAR2(35) NOT NULL The literal unique identifier associated with a given bank/counterparty account.

    Prompt Table: BANK_ACCT_DVW3

    6 RECON_CYCLE_NBR Number(10,0) DECIMAL(10) NOT NULL The bank statement ID.

    Prompt Table: %EDITTABLE

    7 RECON_ORIGIN Character(1) VARCHAR2(1) NOT NULL Recon Origin
    S=Scheduled Origin
    U=User Origin
    8 PROCESS_FREQUENCY Character(1) VARCHAR2(1) NOT NULL Process Frequency
    A=Always Process
    N=Don't Run
    O=Process Once

    Default Value: A

    9 PROCESS_STATUS Character(1) VARCHAR2(1) NOT NULL Process Status
    A=Active
    C=Successfully Completed
    E=Completed With Errors
    N=Not Yet Processed
    P=Processing Now
    X=No Success

    Default Value: N

    10 PROCESS_ORIG Character(1) VARCHAR2(1) NOT NULL Process Origin
    N=Other Source
    P=Process Scheduler

    Default Value: N

    11 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    12 DTTM_STAMP_SEC DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    13 BNK_STMT_TYPE Character(1) VARCHAR2(1) NOT NULL Bank statement type
    1=Current Day
    2=Previous Day
    3=Statement Analysis

    Default Value: 2

    14 SELECT_DT_OPTN Character(1) VARCHAR2(1) NOT NULL Date Type
    1=Specific Dates
    2=Relative Dates

    Default Value: 2

    15 FROM_DATE Date(10) DATE From Date

    Default Value: %date

    16 TO_DATE Date(10) DATE To Date

    Default Value: %date

    17 SRCH_DAYS_FROM Number(5,0) INTEGER NOT NULL Days Back
    18 SRCH_DAYS_TO Number(5,0) INTEGER NOT NULL Days Ahead
    19 PROCESS_ALL_ACCT Character(1) VARCHAR2(1) NOT NULL Process Flag
    N=No
    Y=Yes

    Default Value: N