CURR_STEP_RVALF

(SQL Table)
 Index Back

  • Parent record: CURR_STEP_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: CURR_STEP_TBL.SETID

    2 CURR_STEP Character(10) VARCHAR2(10) NOT NULL Process Step

    Default Value: CURR_STEP_TBL.CURR_STEP

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

    Default Value: CURR_STEP_TBL.VERSION_NUM

    4 EFFDT Date(10) DATE Effective Date

    Default Value: CURR_STEP_TBL.EFFDT

    5 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

    Prompt Table: CFS_CUR_NOB_VW

    6 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

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

    Prompt Table: %EDITTABLE3

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

    Prompt Table: TREE_LEVEL_VW