RS_GRR_HDR

(SQL Table)
 Index Back

Generic Request Header

Generic Resource Request Header

  • Parent Record Of RS_GRR_CNSD RS_GRR_QL_ATTR RS_GRR_QL_ATVL RS_GRR_QL_COMP RS_GRR_QL_DEG RS_GRR_QL_LIC RS_GRR_QL_LNG RS_GRR_QL_MEM RS_GRR_QL_NOTE RS_GRR_SCHED RS_GRR_STS

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

    Prompt Table: SP_BU_PC_NONVW

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

    Default Value: NEXT

    3 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

    Prompt Table: SP_PROJ_NONVW

    4 TEAM_MEMBER Character(30) VARCHAR2(30) NOT NULL Team Member
    5 PLAN_STARTDT Date(10) DATE Planned Start Date

    Default Value: PROJECT.START_DT

    6 PLAN_ENDDT Date(10) DATE Planned End Date

    Default Value: PROJECT.END_DT

    7 PLAN_PROJROLE Character(15) VARCHAR2(15) NOT NULL Requirement Project Role

    Prompt Table: PROJ_ROLE

    8 POOL_ID Character(10) VARCHAR2(10) NOT NULL Pool ID field.

    Default Value: UNASSIGNED

    9 PER_STATUS Character(1) VARCHAR2(1) NOT NULL Personnel Status
    E=Employee
    N=Non-Employee
    10 REGION_CD Character(10) VARCHAR2(10) NOT NULL Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to.
    11 ASSIGNMENT_ID Character(15) VARCHAR2(15) NOT NULL Work Assignment ID

    Prompt Table: RS_ASSIGNMENT

    12 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: RS_WRKR_ADD_VW

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