SA_REQUEST_DTL

(SQL Table)
 Index Back

Request Details

This table contains the attributes of the individual report requests.

  • Parent record: SA_REQUEST_HDR

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 REPORT_REQUEST_NBR Character(9) VARCHAR2(9) NOT NULL Report Request Nbr

    Default Value: SA_REQUEST_HDR.REPORT_REQUEST_NBR

    2 REQUEST_SEQ_NBR Number(5,0) INTEGER NOT NULL Request Seq Nbr
    3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: %EDITTABLE3

    4 SEND_TO_NAME Character(55) VARCHAR2(55) NOT NULL Send To
    5 USE_EXT_ORG Character(1) VARCHAR2(1) NOT NULL Specify External Org ID

    Y/N Table Edit

    Default Value: N

    6 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID

    Prompt Table: EXT_ORG_TBL

    7 ORG_LOCATION Number(3,0) SMALLINT NOT NULL Location Nbr

    Prompt Table: ORG_LOC_ADDR_VW

    8 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: SCC_CNT_ADFMTVW

    9 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
    10 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
    11 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
    12 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
    13 CITY Character(30) VARCHAR2(30) NOT NULL City
    14 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
    15 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
    16 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
    AB=House Boat Reference
    WW=House Trailer Reference
    17 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
    18 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
    19 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
    20 COUNTY Character(30) VARCHAR2(30) NOT NULL County
    21 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: STATE_TBL

    22 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    23 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
    24 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

    Y/N Table Edit

    25 NUMBER_OF_COPIES Number(2,0) SMALLINT NOT NULL Number of Copies

    Default Value: SA_REQUEST_HDR.NUMBER_OF_COPIES

    26 COMPLETION_CODE Character(4) VARCHAR2(4) NOT NULL Completion Code
    000=Successful
    100=Holds
    500=Warning
    27 WHAT_IF_FL Character(1) VARCHAR2(1) NOT NULL Use Career Simulation

    Y/N Table Edit

    Default Value: N

    28 ACAD_CAREER Character(4) VARCHAR2(4) NOT NULL Academic Career
    BAC=Bachelor (NLD)
    BBL=Vocational Coaching (NLD)
    BOL=Vocational Training (NLD)
    BUSN=Graduate Business
    CNED=Continuing Education
    CRED=Semester Credit
    EDU=Education (NLD)
    EXED=Extended Education
    GRAD=Graduate
    LAW=Law
    MEDS=Medical School
    NONA=Non Award
    PGRD=Postgraduate
    RSCH=Research
    TECH=Technical
    UENG=Undergraduate Engineering
    UGRD=Undergraduate
    VAVO=Advanced General Educ. (NLD)
    VETM=Veterinary Medicine

    Prompt Table: SAA_CARSEQ_VW

    29 STDNT_CAR_NBR Number(3,0) SMALLINT NOT NULL Student Career Nbr

    Prompt Table: SAA_ACAD_PRG_VW

    30 ACAD_CAREER_OVRD Character(4) VARCHAR2(4) NOT NULL In What-If Requirements Analysis, the target Career for the model.
    BUSN=Graduate Business
    CNED=Continuing Education
    CRED=Semester Credit
    EXED=Extended Education
    GRAD=Graduate
    LAW=Law
    MEDS=Medical School
    TECH=Technical
    UENG=Undergraduate Engineering
    UGRD=Undergraduate
    VETM=Veterinary Medicine

    Prompt Table: ACAD_CAR_TBL

    31 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program

    Prompt Table: SAA_ACAD_PRG_VW

    32 ACAD_PROG_OVRD Character(5) VARCHAR2(5) NOT NULL In What-If Requirements Analysis, the target Program for the model.

    Prompt Table: ACAD_PR_OV_VW

    33 ACAD_PROG_REQ Character(4) VARCHAR2(4) NOT NULL Program Requirement Term

    Prompt Table: TERM_REQ_VW

    34 ACAD_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Plan

    Prompt Table: SAA_ACAD_PLN_VW

    35 ACAD_PLAN_OVRD Character(10) VARCHAR2(10) NOT NULL In What-If Requirements Analysis, the target Career for the model.

    Prompt Table: ACAD_PL_OV_VW

    36 ACAD_PLAN_REQ Character(4) VARCHAR2(4) NOT NULL Plan Requirement Term

    Prompt Table: TERM_REQ_VW

    37 ACAD_SUB_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Sub-Plan

    Prompt Table: SAA_ACAD_SPL_VW

    38 ACAD_SUB_PLAN_OVRD Character(10) VARCHAR2(10) NOT NULL In What-If Requirements Analysis, the target Sub-Plan for the model.

    Prompt Table: ACAD_SP_OV_VW

    39 ACAD_SUB_PLAN_REQ Character(4) VARCHAR2(4) NOT NULL In What-If Requirements Analysis, the new requirement term for the override Sub-Plan

    Prompt Table: TERM_REQ_VW

    40 WHIF_CRSE_COUNT Number(3,0) SMALLINT NOT NULL Student what-if course count
    41 USE_STORED_WHAT_IF Character(1) VARCHAR2(1) NOT NULL This field is used to indicate if a transcript request is to process an AA report using a stored what-if.

    Y/N Table Edit

    42 CAR_REQ_TERM Character(4) VARCHAR2(4) NOT NULL Career requirement term used for AA.

    Prompt Table: TERM_REQ_VW

    43 ASOF_DATE Date(10) DATE This field is used all over campus solutions to hold the value of an as of date to be used in different processing.
    44 USE_CMPLT_MODEL Character(1) VARCHAR2(1) NOT NULL This fiels is a flag that is passed in the what-if report request for academic advisement to flag whether or not to include the completed transfer credit models when running an advisement report.
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N