RS_GRR_STS

(SQL Table)
 Index Back

Generic Request Statuses

Generic Resource Request Status.

  • Parent record: RS_GRR_HDR

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

    Default Value: RS_GRR_HDR.BUSINESS_UNIT

    2 GRR_ID Character(10) VARCHAR2(10) NOT NULL Generic Resource Request ID.

    Default Value: RS_GRR_HDR.GRR_ID

    3 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence

    Default Value: 0

    4 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    5 DATE_ENTERED Date(10) DATE Date

    Default Value: %Date

    6 APPROVER_TYPE Character(1) VARCHAR2(1) NOT NULL Defines types of approvers, including originator, regular approver and auditor.
    A=Approver
    O=Originator
    P=Project Manager
    T=Post-Pay Auditor
    U=Pre-Pay Auditor

    Default Value: O

    7 GRR_STATUS Character(1) VARCHAR2(1) NOT NULL Generic Resource Request Status
    A=Allocated
    F=Fulfilled
    R=Rejected
    V=Pending Approval
    X=Cancelled

    Default Value: V

    8 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254