FLDREQ_FLUID_VW

(SQL View)
 Index Back

Field Request Table

Field Request Table

SELECT A.FLD_REQUEST_ID , A.SETID , A.FIELDNAME1 , F.Longname , F.Shortname , A.FLD_REQ_FLD_ACT , A.FIELDVALUE1 , A.FLD_REQ_STATUS , A.REQUESTOR_ID , A.PHONE , A.EMAILID , OP.OPRDEFNDESC , A.GL_ENTERED_DTTM , A.GL_UPDATED_BY , A.GL_UPDATED_DTTM , A.ATTACHMENT_EXIST , A.COMMENTS , B.FIELD_VALUE_DATE , C.FLD_REQ_VALUE_GL , D.FLD_REQ_VALUE_GL , B.FIELD_VALUE_DATE , B.FIELD_VALUE_DATE FROM %Table(FLD_REQUEST) A , %Table(FLD_REQ_COR_DTL) B , %Table(FLD_REQ_COR_DTL) C , %Table(FLD_REQ_COR_DTL) D , PSDBFLDLABL F , PSOPRDEFN OP WHERE A.FLD_REQUEST_ID = B.FLD_REQUEST_ID AND B.FIELDNAME2 = 'EFFDT' AND A.FLD_REQUEST_ID = C.FLD_REQUEST_ID AND C.FIELDNAME2 = 'EFF_STATUS' AND A.FLD_REQUEST_ID = D.FLD_REQUEST_ID AND D.FIELDNAME2 = 'DESCR' AND F.FIELDNAME = A.FIELDNAME1 AND F.DEFAULT_LABEL = 1 AND A.GL_ENTERED_BY = OP.OPRID AND A.FIELDNAME1 <> 'PROJECT_ID' UNION ALL SELECT A.FLD_REQUEST_ID , A.SETID , A.FIELDNAME1 , F.Longname , F.Shortname , A.FLD_REQ_FLD_ACT , A.FIELDVALUE1 , A.FLD_REQ_STATUS , A.REQUESTOR_ID , A.PHONE , A.EMAILID , OP.OPRDEFNDESC , A.GL_ENTERED_DTTM , A.GL_UPDATED_BY , A.GL_UPDATED_DTTM , A.ATTACHMENT_EXIST , A.COMMENTS , B.FIELD_VALUE_DATE , C.FLD_REQ_VALUE_GL , D.FLD_REQ_VALUE_GL , B.FIELD_VALUE_DATE , BA.FIELD_VALUE_DATE FROM %Table(FLD_REQUEST) A , %Table(FLD_REQ_COR_DTL) B , %Table(FLD_REQ_COR_DTL) BA , %Table(FLD_REQ_COR_DTL) C , %Table(FLD_REQ_COR_DTL) D , PSDBFLDLABL F , PSOPRDEFN OP WHERE A.FLD_REQUEST_ID = B.FLD_REQUEST_ID AND B.FIELDNAME2 = 'START_DT' AND A.FLD_REQUEST_ID = BA.FLD_REQUEST_ID AND BA.FIELDNAME2 = 'END_DT' AND A.FLD_REQUEST_ID = C.FLD_REQUEST_ID AND C.FIELDNAME2 = 'EFF_STATUS' AND A.FLD_REQUEST_ID = D.FLD_REQUEST_ID AND D.FIELDNAME2 = 'DESCR' AND F.FIELDNAME = A.FIELDNAME1 AND F.DEFAULT_LABEL = 1 AND A.GL_ENTERED_BY = OP.OPRID AND A.FIELDNAME1 = 'PROJECT_ID'

  • Related Language Record: FLDREQ_FLLAN_VW

    • # 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 LONGNAME Character(30) VARCHAR2(30) NOT NULL Long Name
    5 SHORTNAME Character(15) VARCHAR2(15) NOT NULL Field Short Name
    6 FLD_REQ_FLD_ACT Character(1) VARCHAR2(1) NOT NULL Field Request Field Action
    A=Add
    U=Update

    Default Value: A

    7 FIELDVALUE1 Character(30) VARCHAR2(30) NOT NULL Field Value
    8 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

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

    Prompt Table: OPRID_VW

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

    Prompt Table: OPRID_VW

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

    Default Value: N

    17 COMMENTS Long Character CLOB Comments
    18 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    19 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    20 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    21 START_DATE Date(10) DATE Start Date for Gen Standing PO
    22 END_DATE Date(10) DATE End Date