SSR_RS_REQSTHDR

(SQL Table)
Index Back

Change Requests Header

Change Request Header Record

  • Parent Record Of SAA_NOTE_ATTACH SSR_RS_REQSTATT
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PEOPLE_SRCH

    2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

    3 SSR_RS_REQUEST_ID Number(5,0) INTEGER NOT NULL Service Request ID
    4 SSR_RS_RQUEST_TYPE Character(5) VARCHAR2(5) NOT NULL Service Request Type

    Prompt Table: SSR_RS_REQTYPVW

    5 SSR_RS_CANDIT_NBR Character(12) VARCHAR2(12) NOT NULL Last Candidate Number

    Prompt Table: SSR_RS_CND_SRCH

    6 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
    7 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
    8 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
    9 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time
    10 SSR_RS_REQ_SUBTYPE Character(5) VARCHAR2(5) NOT NULL Service Request Subtype

    Prompt Table: SSR_RS_RQSUBTYP

    11 SSR_REQ_SEQUENCE Number(12,0) DECIMAL(12) NOT NULL Unique sequence generated ID for a Serive Request