FLD_REQ_TC_FLDS

(SQL Table)
 Index Back

Field Request Core Fields

Field Request Template Core Fields

  • Parent record: FLD_REQ_TMPLT

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

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 FIELDNAME1 Character(18) VARCHAR2(18) NOT NULL Field Name 1

    Prompt Table: FLD_REQ_SFLD_VW

    3 FIELDNAME2 Character(18) VARCHAR2(18) NOT NULL Field Name

    Prompt Table: FLD_REQ_FLD_DVW

    4 EDITTABLE Character(15) VARCHAR2(15) NOT NULL Edit Table

    Prompt Table: RECDEFN_VW

    5 FLD_REQ_DISP_OPTN Character(1) VARCHAR2(1) NOT NULL Field Request Display Option
    N=Do Not Display
    O=Optional
    R=Required

    Default Value: O

    6 REQUIRED_FLG Character(1) VARCHAR2(1) NOT NULL Required Flag

    Y/N Table Edit

    Default Value: N

    7 DELIVERED_FLG Character(1) VARCHAR2(1) NOT NULL Delivered Flag

    Y/N Table Edit

    Default Value: N