REQ_SE_HDR_VW

(SQL View)
 Index Back

REQ Header PTSF view


SELECT A.BUSINESS_UNIT , A.REQ_ID , A.REQ_NAME , A.REQUESTOR_ID , B.DESCR , A.REQ_STATUS , A.REQ_DT , A.OPRID_ENTERED_BY , A.ORIGIN , (CASE WHEN V.SES_VN_ATTR_L_DTTM > A.LAST_DTTM_UPDATE THEN V.SES_VN_ATTR_L_DTTM ELSE A.LAST_DTTM_UPDATE END) , (CASE WHEN C.OPRDEFNDESC IS NOT NULL THEN C.OPRDEFNDESC ELSE A.REQUESTOR_ID END) , A.HOLD_STATUS , A.ORIG_TRAN , A.OPRID_MODIFIED_BY , A.OPRID_APPROVED_BY , A.ENTERED_DT , A.APPROVAL_DT , A.PO_POST_STATUS , A.APPL_JRNL_ID_ENC , A.POST_DOC , A.DST_CNTRL_ID , A.ACCOUNTING_DT , A.PROCESS_INSTANCE , A.IN_PROCESS_FLG , A.ACTIVITY_DATE , A.NEXT_MOD_SEQ_NBR , A.CURRENCY_CD , A.RT_TYPE , A.RATE_DIV , A.RATE_MULT , A.CURRENCY_CD_BASE , A.BUDGET_HDR_STATUS , A.KK_AMOUNT_TYPE , A.KK_TRAN_OVER_FLAG , A.KK_TRAN_OVER_OPRID , A.KK_TRAN_OVER_DTTM , A.BUDGET_CHECK , A.BUDGET_HDR_STS_NP , A.BUDGET_HDR_STS_PR , A.CHNG_ORD_BATCH , A.REQ_STATUS , A.REQ_TYPE , A.REQ_DT , %Substring(%Cast(A.REQ_DT, Date, Character), 6, 2) , %Substring(%Cast(A.REQ_DT, Date, Character), 6, 2) , A.BUSINESS_UNIT FROM ((PS_REQ_HDR A LEFT OUTER JOIN PS_REQ_SE_LINE_VND V ON V.BUSINESS_UNIT = A.BUSINESS_UNIT AND V.REQ_ID = A.REQ_ID) LEFT OUTER JOIN PSOPRDEFN C ON A.REQUESTOR_ID = C.OPRID) , PS_BUS_UNIT_TBL_FS B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT

  • Related Language Record: REQ_SE_HDR_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID

    Default Value: NEXT

    3 REQ_NAME Character(30) VARCHAR2(30) NOT NULL Requisition Name
    4 REQUESTOR_ID Character(30) VARCHAR2(30) NOT NULL Requestor id

    Default Value: OPR_DEF_TBL_PM.REQUESTOR_ID

    Prompt Table: %EDITTABLE16

    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 REQ_STATUS Character(4) VARCHAR2(4) NOT NULL Req status
    A=Approved
    C=Complete
    D=Denied
    I=Initial
    LA=Line Approved
    O=Open
    P=Pending Approval
    V=Preview
    X=Canceled

    Default Value: REQUESTOR_TBL.REQ_STATUS

    7 REQ_DT Date(10) DATE NOT NULL Requisition Date

    Default Value: %date

    8 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    9 ORIGIN Character(3) VARCHAR2(3) NOT NULL Origin

    Prompt Table: ORIGIN_PO

    10 LAST_DTTM_UPDATE 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.
    11 OPRDEFNDESC Character(30) VARCHAR2(30) NOT NULL Description field for a user
    12 HOLD_STATUS Character(1) VARCHAR2(1) NOT NULL Hold From Further Processing

    Y/N Table Edit

    Default Value: N

    13 ORIG_TRAN Character(3) VARCHAR2(3) NOT NULL Transaction Originated From
    EPO=eProcurement Requisition
    REQ=Purchasing Requisition

    Default Value: REQ

    14 OPRID_MODIFIED_BY Character(30) VARCHAR2(30) NOT NULL Last User to Modify Entered By 07/25/2011:Ensured that OPRID_MODIFIED_BY is set with format type of MixedCase.
    15 OPRID_APPROVED_BY Character(30) VARCHAR2(30) NOT NULL Approved By
    16 ENTERED_DT Date(10) DATE Entered on

    Default Value: %date

    17 APPROVAL_DT Date(10) DATE Date of Approval
    18 PO_POST_STATUS Character(1) VARCHAR2(1) NOT NULL Post Status
    D=Distributed
    N=None

    Default Value: N

    19 APPL_JRNL_ID_ENC Character(10) VARCHAR2(10) NOT NULL Encumbrance

    Default Value: BUS_UNIT_INTFC.APPL_JRNL_ID_PREM

    20 POST_DOC Character(1) VARCHAR2(1) NOT NULL Post Document

    Y/N Table Edit

    Default Value: Y

    21 DST_CNTRL_ID Character(10) VARCHAR2(10) NOT NULL Accounting Template

    Default Value: BUS_UNIT_OPT_PM.DST_CNTRL_ID

    22 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
    23 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    24 IN_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL In process flag

    Y/N Table Edit

    Default Value: N

    25 ACTIVITY_DATE Date(10) DATE Last Activity

    Default Value: %date

    26 NEXT_MOD_SEQ_NBR Number(3,0) SMALLINT NOT NULL Next Modification Number
    27 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    28 RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.

    Default Value: BUS_UNIT_TBL_PM.RT_TYPE

    29 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor

    Default Value: 1

    30 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
    31 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency

    Default Value: BUS_UNIT_TBL_PM.CURRENCY_CD

    32 BUDGET_HDR_STATUS Character(1) VARCHAR2(1) NOT NULL Budget Checking Header Status
    E=Error in Budget Check
    I=Document In Processing
    N=Not Budget Checked
    P=Provisionally Valid
    V=Valid
    33 KK_AMOUNT_TYPE Character(1) VARCHAR2(1) NOT NULL Commitment Control Amount Type
    0=Budget
    1=Actuals and Recognized
    2=Encumbrance
    3=Pre-Encumbrance
    4=Collected Revenue
    5=Planned
    7=Actuals, Recognize and Collect
    9=Dynamic
    34 KK_TRAN_OVER_FLAG Character(1) VARCHAR2(1) NOT NULL Commitment Control source transaction override flag
    N=No
    Y=Yes
    35 KK_TRAN_OVER_OPRID Character(30) VARCHAR2(30) NOT NULL Commitment Control source transaction override operator
    36 KK_TRAN_OVER_DTTM DateTime(26) TIMESTAMP Commitment Control source transaction override datetime
    37 BUDGET_CHECK Character(1) VARCHAR2(1) NOT NULL Budget Checked
    N=No
    Y=Yes
    38 BUDGET_HDR_STS_NP Character(1) VARCHAR2(1) NOT NULL Budget Ch'k Hdr Sts NonProrate
    E=Error in Budget Check
    N=Not Budget Checked
    P=Provisionally Valid
    V=Valid Budget Check

    Default Value: V

    39 BUDGET_HDR_STS_PR Character(1) VARCHAR2(1) NOT NULL Budget Ch'k Hdr Sts Prorated
    E=Error in Budget Check
    N=Not Budget Checked
    V=Valid Budget Check

    Default Value: V

    40 CHNG_ORD_BATCH Number(3,0) SMALLINT NOT NULL Change Order Number
    41 REQ_STATUS2 Character(4) VARCHAR2(4) NOT NULL Req status
    A=Approved
    C=Complete
    D=Denied
    I=Initial
    LA=Line Approved
    O=Open
    P=Pending Approval
    V=Preview
    X=Canceled
    42 REQ_TYPE Character(4) VARCHAR2(4) NOT NULL Requisition Type
    BO=Bill Only
    BR=Bill and Replace
    STD=Standard
    43 SES_DOCUMENT_DATE Date(10) DATE Document Date
    44 SES_MONTH Character(2) VARCHAR2(2) NOT NULL Month
    01=01: January
    02=02: February
    03=03: March
    04=04: April
    05=05: May
    06=06: June
    07=07: July
    08=08: August
    09=09: September
    10=10: October
    11=11: November
    12=12: December
    45 SES_MONTH2 Character(2) VARCHAR2(2) NOT NULL Month
    01=01: January
    02=02: February
    03=03: March
    04=04: April
    05=05: May
    06=06: June
    07=07: July
    08=08: August
    09=09: September
    10=10: October
    11=11: November
    12=12: December
    46 DESCR120 Character(120) VARCHAR2(120) NOT NULL Description