SAD_FLSS_SETUP

(SQL Table)
 Index Back

Applicant Fluid SS Setup

Applicant Fluid SS Setup

  • Parent Record Of SAD_FLSS_DPA SAD_FLSS_PP_VW SAD_FLSS_V_AC SAD_FLSS_V_AT SAD_FLSS_V_PP SAD_SS_SETUP_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

    2 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: ACAD_CAR_TBL

    3 ADMIT_TERM Character(4) VARCHAR2(4) NOT NULL Admit Term

    Prompt Table: TERM_TBL

    4 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number

    Default Value: 1

    5 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
    A=Active
    I=Inactive

    Default Value: A

    6 BEGINS Number(3,0) SMALLINT NOT NULL BEGINS
    7 ENDS Number(3,0) SMALLINT NOT NULL ENDS
    8 BEGIN_DT Date(10) DATE Begin Date
    9 END_DT Date(10) DATE end date
    10 BEGIN_TM Time(15) TIMESTAMP Begin Time

    Default Value: 00:00

    11 MANUAL_ACTIVATION Character(1) VARCHAR2(1) NOT NULL MANUAL_ACTIVATION

    Y/N Table Edit

    Default Value: N

    12 ACTIVATE Character(1) VARCHAR2(1) NOT NULL Index Active

    Y/N Table Edit

    Default Value: N

    13 REMINDER_SEND Date(10) DATE REMINDER_SEND
    14 REMINDER_EMPLID Character(11) VARCHAR2(11) NOT NULL REMINDER_EMPLID
    15 REMINDER_SEL Character(4) VARCHAR2(4) NOT NULL REMINDER_SEL
    E=Email
    S=SMS
    16 CONTACTEMAIL Character(70) VARCHAR2(70) NOT NULL Integration Server Business Entity Contact Email
    17 CONTACTPHONENBR Character(24) VARCHAR2(24) NOT NULL Integration Server Business Entity Contact Phone Number
    18 CONTACTURL Character(254) VARCHAR2(254) NOT NULL Integration Server Business Entity Internet URL (Universal Resource Locator)
    19 CONTACT_EMPLID Character(11) VARCHAR2(11) NOT NULL Contact - Vacancy Announcement

    Prompt Table: PERSON

    20 CONTACTTEXTID Character(18) VARCHAR2(18) NOT NULL CONTACTTEXTID

    Prompt Table: SAD_SSTEXT_VW

    21 ADO_DISPLAY_TO Date(10) DATE Send Reminder
    22 ADO_ACCEPT Character(4) VARCHAR2(4) NOT NULL Accept/Decline Accept field
    A=Activity Guides
    M=Modal Confirm
    23 ADO_DECLINE Character(4) VARCHAR2(4) NOT NULL Decline field
    A=Activity Guides
    M=Modal Confirm
    24 ADO_A_MC Character(18) VARCHAR2(18) NOT NULL Accept Decline Option, Accept Modal

    Prompt Table: SAD_SSTEXT_VW

    25 ADO_D_MC Character(18) VARCHAR2(18) NOT NULL Accept Decline Option, Decline Modal

    Prompt Table: SAD_SSTEXT_VW

    26 ADO_A_AG Character(31) VARCHAR2(31) NOT NULL Accept Decline Option, Accept Activity Guide

    Prompt Table: SAD_PTAI_VW

    27 ADO_D_AG Character(31) VARCHAR2(31) NOT NULL Accept Decline Option, Decline Activity Guide

    Prompt Table: SAD_PTAI_VW

    28 APPLICATION_MODEL Character(1) VARCHAR2(1) NOT NULL APPLICATION_MODEL
    1=Application Model 1
    2=Application Model 2

    Default Value: 1

    29 DELAYDAYS Number(3,0) SMALLINT NOT NULL DELAYDAYS
    30 SAD_GENERICMSG Character(18) VARCHAR2(18) NOT NULL Message Number

    Prompt Table: SAD_SSTEXT_VW

    31 DEFR_REQ_ALLOW Character(1) VARCHAR2(1) NOT NULL Request Allow
    N=No
    Y=Yes
    32 DEFR_PI_TEXTID Character(18) VARCHAR2(18) NOT NULL Deferral PI Text ID

    Prompt Table: SAD_SSTEXT_VW

    33 DEFR_INFO_TEXTID Character(18) VARCHAR2(18) NOT NULL Deferral Info Text ID

    Prompt Table: SAD_SSTEXT_VW

    34 DEFR_PRCS_ID Character(30) VARCHAR2(30) NOT NULL Process ID

    Prompt Table: SAD_AWETXNVW

    35 DEFR_DEFN_ID Character(30) VARCHAR2(30) NOT NULL Deferral Definition ID

    Prompt Table: SAD_DFR_EOVW

    36 WITH_SS_ALLOW Character(1) VARCHAR2(1) NOT NULL WITH_SS_ALLOW
    N=No
    Y=Yes
    37 WITH_INSERT_ACTION Character(1) VARCHAR2(1) NOT NULL WITH_INSERT_ACTION
    N=No
    Y=Yes
    38 WITH_PI_TEXTID Character(18) VARCHAR2(18) NOT NULL WITH_PI_TEXTID

    Prompt Table: SAD_SSTEXT_VW

    39 WITH_INFO_TEXTID Character(18) VARCHAR2(18) NOT NULL WITH_INFO_TEXTID

    Prompt Table: SAD_SSTEXT_VW

    40 WITH_PRCS_ID Character(30) VARCHAR2(30) NOT NULL WITH_PRCS_ID

    Prompt Table: SAD_AWETXNVW

    41 WITH_DEFN_ID Character(30) VARCHAR2(30) NOT NULL WITH_DEFN_ID

    Prompt Table: SAD_WTH_EOVW

    42 PROG_REASON Character(4) VARCHAR2(4) NOT NULL Action Reason

    Prompt Table: PROG_RSN_TBL

    43 PPC_ALLOW Character(1) VARCHAR2(1) NOT NULL PPC_ALLOW
    N=No
    Y=Yes
    44 PPC_PI_TEXTID Character(18) VARCHAR2(18) NOT NULL PPC_PI_TEXTID

    Prompt Table: SAD_SSTEXT_VW

    45 PPC_INFO_TEXTID Character(18) VARCHAR2(18) NOT NULL PPC_INFO_TEXTID

    Prompt Table: SAD_SSTEXT_VW

    46 PPC_PRCS_ID Character(30) VARCHAR2(30) NOT NULL PPC_PRCS_ID

    Prompt Table: SAD_AWETXNVW

    47 PPC_DEFN_ID Character(30) VARCHAR2(30) NOT NULL PPC_DEFN_ID

    Prompt Table: SAD_PPC_EOVW

    48 WAIT_ALLOW Character(1) VARCHAR2(1) NOT NULL WAIT_ALLOW

    Y/N Table Edit

    49 WAIT_PI_TEXTID Character(18) VARCHAR2(18) NOT NULL WAIT_PI_TEXTID

    Prompt Table: SAD_SSTEXT_VW

    50 WAIT_AVAIL_DT Date(10) DATE WAIT_AVAIL_DT
    51 WAIT_MP_TEXTID Character(18) VARCHAR2(18) NOT NULL WAIT_MP_TEXTID

    Prompt Table: SAD_SSTEXT_VW

    52 ACC_MRC_ALLOW Character(1) VARCHAR2(1) NOT NULL Allow changes to offer

    Y/N Table Edit

    53 ACC_MRC_FROM Date(10) DATE From
    54 ACC_MRC_TO Date(10) DATE To
    55 DEC_MRC_ALLOW Character(1) VARCHAR2(1) NOT NULL Allow changes to offer

    Y/N Table Edit

    56 DEC_MRC_FROM Date(10) DATE From
    57 DEC_MRC_TO Date(10) DATE To
    58 REQ_MENU_ACTIVATE Character(1) VARCHAR2(1) NOT NULL Display Request Item Menu

    Y/N Table Edit

    Default Value: Y