CLOSE_REQUEST

(SQL Table)
 Index Back

Ledger Closing Batch Request

  • Parent Record Of CLOSE_REQ_STEP CLOSE_UNDO_BKCD

    • # 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 REQUEST_NBR Number(4,0) SMALLINT NOT NULL Request Number

    Default Value: 9999

    4 PROCESS_FREQUENCY Character(1) VARCHAR2(1) NOT NULL Process Frequency
    A=Always Process
    N=Don't Run
    O=Process Once

    Default Value: N

    5 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

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

    Default Value: N

    7 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    8 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.
    9 CLOSE_REQ_TYPE Character(1) VARCHAR2(1) NOT NULL Request type for General Ledger Close. When = 'C', close ledger, when ='U', undo previous clsoe.
    C=Close
    U=UnClose

    Default Value: C

    10 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

    Prompt Table: SP_BU_GL_NONVW

    11 CLOSING_SET Character(20) VARCHAR2(20) NOT NULL Closing Rule

    Prompt Table: CLOSING_RULE_VW

    12 VERSION_NUM Number(3,0) SMALLINT NOT NULL Version Number

    Default Value: 0

    13 CLOSING_TYPE Character(1) VARCHAR2(1) NOT NULL Closing Type
    I=Interim
    Y=Year End

    Default Value: I

    14 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group

    Prompt Table: SP_BULGRP_NONVW

    15 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger

    Prompt Table: LED_GRP_LED_TBL

    16 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
    17 HOW_FIELD_SPECIFY Character(1) VARCHAR2(1) NOT NULL How Specified
    1=All Detail Values
    2=Selected Detail Values
    3=Detail - Selected Parents
    4=Selected Tree Nodes
    5=Children at a Level
    6=All Nodes at Selected Levels
    7=Selected Summary ChrtFld Nodes
    9=Value Mask
    A=Account Type
    R=Range of Values

    Default Value: 2

    18 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name

    Prompt Table: BU_TREE_VW

    19 TREE_LEVEL Character(10) VARCHAR2(10) NOT NULL Tree Level Number

    Prompt Table: TREE_LEVEL_VW

    20 CLOSE_DATE_OPTION Character(1) VARCHAR2(1) NOT NULL Process date options for closing process.
    A=As of Date
    P=BU Process Date

    Default Value: P

    21 AS_OF_DATE Date(10) DATE As of Date
    22 TREE_SETID Character(5) VARCHAR2(5) NOT NULL Tree SetID

    Prompt Table: SP_SETID_NONVW

    23 CHECK_ONLY Character(1) VARCHAR2(1) NOT NULL Check only, Do not process

    Y/N Table Edit

    Default Value: N

    24 CLOSE_GRP_ID Character(20) VARCHAR2(20) NOT NULL Closing Process Group

    Prompt Table: CLOSE_GRP0_VW

    25 VERSION_GRP Number(3,0) SMALLINT NOT NULL Group Version

    Default Value: 0

    26 RTBL_LAST_STEP Character(30) VARCHAR2(30) NOT NULL Last step completed in RTBL Scenario processing.
    27 RTBL_STOP_STEP Character(30) VARCHAR2(30) NOT NULL Step for Check Point in RTBL Scenario processing.
    28 BURST_MODE_FLG Character(1) VARCHAR2(1) NOT NULL Burst Mode

    Default Value: Y

    29 WHERE_BU Character(254) VARCHAR2(254) NOT NULL WHERE CLAUSE
    30 RTBL_MODE Character(1) VARCHAR2(1) NOT NULL RTBL Mode

    Y/N Table Edit

    Default Value: N

    31 RTBL_COMBO_FLAG Character(1) VARCHAR2(1) NOT NULL RTBL Combination Edit Flag

    Y/N Table Edit

    Default Value: N

    32 SCE_ID Character(10) VARCHAR2(10) NOT NULL ID
    33 USE_GTT Character(1) VARCHAR2(1) NOT NULL Use Global Temp Table Flag

    Y/N Table Edit

    Default Value: N

    34 LED_REQ_TYPE Character(1) VARCHAR2(1) NOT NULL Specifies if the process request uses full ledger or incremental ledger data.
    F=Full
    I=Incremental

    Default Value: F

    35 CLOSE_BOOKCD Character(1) VARCHAR2(1) NOT NULL Close by Book Code Option

    Y/N Table Edit

    Default Value: N