FLD_REQUEST

(SQL Table)
 Index Back

Field Request Table

Field Request Table

  • Parent Record Of BO_REQ_AC_XREF BO_REQ_ATTRIB FLDREQ_TREE_VW FLDREQ_TREE_WRK FLD_REQUEST_ATT FLD_REQ_AC_XREF FLD_REQ_ATTRIB FLD_REQ_CI_ERR FLD_REQ_COR_DTL FLD_REQ_CUS_DTL FLD_REQ_QST_DTL FLD_REQ_TRE_DTL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 FLD_REQUEST_ID Character(30) VARCHAR2(30) NOT NULL Field Request ID
    2 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

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

    Prompt Table: FLD_REQ_TFLD_VW

    4 FLD_REQ_FLD_ACT Character(1) VARCHAR2(1) NOT NULL Field Request Field Action
    A=Add
    U=Update

    Default Value: A

    5 FIELDVALUE1 Character(30) VARCHAR2(30) NOT NULL Field Value
    6 FLD_REQ_STATUS Character(1) VARCHAR2(1) NOT NULL Field Request Status
    A=Approved
    B=Blank Value
    C=Canceled
    D=Denied
    E=Component Interface Error
    N=Newly Created
    P=Pending Approval
    T=Need Attention

    Default Value: N

    7 REQUESTOR_ID Character(30) VARCHAR2(30) NOT NULL Requestor id

    Prompt Table: OPRID_VW

    8 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
    9 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address
    10 GL_ENTERED_BY Character(30) VARCHAR2(30) NOT NULL Entered By

    Prompt Table: OPRID_VW

    11 GL_ENTERED_DTTM DateTime(26) TIMESTAMP Entered Date/Time
    12 GL_UPDATED_BY Character(30) VARCHAR2(30) NOT NULL Updated By
    13 GL_UPDATED_DTTM DateTime(26) TIMESTAMP Updated Date/Time
    14 ATTACHMENT_EXIST Character(1) VARCHAR2(1) NOT NULL Attachments Exist
    N=N
    Y=Y

    Default Value: N

    15 COMMENTS Long Character CLOB Comments