SAD_FLSS_DPA_VW

(SQL View)
 Index Back

Applicant Fluid SS Display

Applicant Fluid SS Display View

SELECT a.INSTITUTION , a.ACAD_CAREER , a.ADMIT_TERM , a.SEQNO , b.PROG_ACTION , b.PROG_REASON , a.STATUS , a.BEGINS , a.ENDS , a.BEGIN_DT , a.END_DT , a.BEGIN_TM , a.MANUAL_ACTIVATION , a.ACTIVATE , a.REMINDER_SEND , a.REMINDER_EMPLID , a.REMINDER_SEL , a.CONTACTEMAIL , a.CONTACTPHONENBR , a.CONTACTURL , a.CONTACT_EMPLID , a.CONTACTTEXTID , a.ADO_DISPLAY_TO , a.ADO_ACCEPT , a.ADO_DECLINE , a.ADO_A_MC , a.ADO_D_MC , a.ADO_A_AG , a.ADO_D_AG , a.APPLICATION_MODEL , a.DELAYDAYS , a.SAD_GENERICMSG , a.DEFR_REQ_ALLOW , a.DEFR_PI_TEXTID , a.DEFR_INFO_TEXTID , a.DEFR_PRCS_ID , a.DEFR_DEFN_ID , a.WITH_SS_ALLOW , a.WITH_INSERT_ACTION , a.WITH_PI_TEXTID , a.WITH_INFO_TEXTID , a.WITH_PRCS_ID , a.WITH_DEFN_ID , a.PROG_REASON , a.PPC_ALLOW , a.PPC_PI_TEXTID , a.PPC_INFO_TEXTID , a.PPC_PRCS_ID , a.PPC_DEFN_ID , a.WAIT_ALLOW , a.WAIT_PI_TEXTID , a.WAIT_AVAIL_DT , a.WAIT_MP_TEXTID , a.ACC_MRC_ALLOW , a.ACC_MRC_FROM , a.ACC_MRC_TO , a.DEC_MRC_ALLOW , a.DEC_MRC_FROM , a.DEC_MRC_TO , a.REQ_MENU_ACTIVATE , b.APPL_COMP_DESCR , b.APPL_INCO_DESCR , b.SAD_ACTION_DESCR , b.LETTER_CD , b.INFO_TEXT_ID , b.COMP_TEXT_ID , b.INCO_TEXT_ID , b.SAD_DIS_DONOT , b.SAD_DIS_LETTERLINK , b.SAD_DIS_FALINK , b.SAD_DIS_ALTCONTACT , b.SAD_DEFAULTMSG FROM PS_SAD_FLSS_SETUP a , ps_sad_flss_dpa b WHERE a.institution = b.institution AND a.acad_career = b.acad_career AND a.admit_term = b.admit_term AND a.seqno = b.seqno AND a.STATUS = 'A'

# 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 PROG_ACTION Character(4) VARCHAR2(4) NOT NULL Program Action
ACTV=Activate
ADMT=Admit
ADRV=Admission Revocation
APPL=Application
COMP=Completion of Program
COND=Conditional Admit
DATA=Data Change
DDEF=Defer Decision
DEFR=Defer Enrollment
DEIN=Intention to Matriculate
DENY=Deny
DISC=Discontinuation
DISM=Dismissal
LEAV=Leave of Absence
MATR=Matriculation
PLNC=Plan Change
PRGC=Program Change
RADM=Readmit
RAPP=Readmit Application
RECN=Reconsideration
REVK=Revoke Degree
RLOA=Return from Leave of Absence
SPND=Suspension
TRAN=Transfer to Other Career
VDIS=Voluntarily Discontinued
WADM=Administrative Withdrawal
WAIT=Waitlist
WAOF=Waitlist Offer
WAPP=Applicant Withdrawal

Prompt Table: ADM_ACTION_SCTY

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

Prompt Table: PROG_RSN_TBL

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

Default Value: A

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

Default Value: 00:00

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

Y/N Table Edit

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

Y/N Table Edit

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

Prompt Table: PERSON

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

Prompt Table: SAD_SSTEXT_VW

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

Prompt Table: SAD_SSTEXT_VW

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

Prompt Table: SAD_SSTEXT_VW

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

Prompt Table: PTAI_LIST

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

Prompt Table: PTAI_LIST

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

Default Value: 1

31 DELAYDAYS Number(3,0) SMALLINT NOT NULL DELAYDAYS
32 SAD_GENERICMSG Character(18) VARCHAR2(18) NOT NULL Message Number

Prompt Table: SAD_SSTEXT_VW

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

Prompt Table: SAD_SSTEXT_VW

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

Prompt Table: SAD_SSTEXT_VW

36 DEFR_PRCS_ID Character(30) VARCHAR2(30) NOT NULL Process ID
37 DEFR_DEFN_ID Character(30) VARCHAR2(30) NOT NULL Deferral Definition ID
38 WITH_SS_ALLOW Character(1) VARCHAR2(1) NOT NULL WITH_SS_ALLOW
N=No
Y=Yes
39 WITH_INSERT_ACTION Character(1) VARCHAR2(1) NOT NULL WITH_INSERT_ACTION
N=No
Y=Yes
40 WITH_PI_TEXTID Character(18) VARCHAR2(18) NOT NULL WITH_PI_TEXTID

Prompt Table: SAD_SSTEXT_VW

41 WITH_INFO_TEXTID Character(18) VARCHAR2(18) NOT NULL WITH_INFO_TEXTID
42 WITH_PRCS_ID Character(30) VARCHAR2(30) NOT NULL WITH_PRCS_ID
43 WITH_DEFN_ID Character(30) VARCHAR2(30) NOT NULL WITH_DEFN_ID
44 SAD_PROG_REASON Character(4) VARCHAR2(4) NOT NULL SAD_PROG_REASON
45 PPC_ALLOW Character(1) VARCHAR2(1) NOT NULL PPC_ALLOW
N=No
Y=Yes
46 PPC_PI_TEXTID Character(18) VARCHAR2(18) NOT NULL PPC_PI_TEXTID

Prompt Table: SAD_SSTEXT_VW

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

Prompt Table: SAD_SSTEXT_VW

48 PPC_PRCS_ID Character(30) VARCHAR2(30) NOT NULL PPC_PRCS_ID
49 PPC_DEFN_ID Character(30) VARCHAR2(30) NOT NULL PPC_DEFN_ID
50 WAIT_ALLOW Character(1) VARCHAR2(1) NOT NULL WAIT_ALLOW

Y/N Table Edit

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

Prompt Table: SAD_SSTEXT_VW

52 WAIT_AVAIL_DT Date(10) DATE WAIT_AVAIL_DT
53 WAIT_MP_TEXTID Character(18) VARCHAR2(18) NOT NULL WAIT_MP_TEXTID

Prompt Table: SAD_SSTEXT_VW

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

Y/N Table Edit

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

Y/N Table Edit

58 DEC_MRC_FROM Date(10) DATE From
59 DEC_MRC_TO Date(10) DATE To
60 REQ_MENU_ACTIVATE Character(1) VARCHAR2(1) NOT NULL Display Request Item Menu
61 APPL_COMP_DESCR Character(30) VARCHAR2(30) NOT NULL APPL_COMP_DESCR
62 APPL_INCO_DESCR Character(30) VARCHAR2(30) NOT NULL APPL_INCO_DESCR
63 SAD_ACTION_DESCR Character(30) VARCHAR2(30) NOT NULL SAD_ACTION_DESCR
64 LETTER_CD Character(3) VARCHAR2(3) NOT NULL Letter code

Prompt Table: SCC_STN_LTR_TBL

65 INFO_TEXT_ID Character(18) VARCHAR2(18) NOT NULL INFO_TEXT_ID

Prompt Table: SAD_SSTEXT_VW

66 COMP_TEXT_ID Character(18) VARCHAR2(18) NOT NULL COMP_TEXT_ID
67 INCO_TEXT_ID Character(18) VARCHAR2(18) NOT NULL INCO_TEXT_ID
68 SAD_DIS_DONOT Character(1) VARCHAR2(1) NOT NULL SAD_DIS_DONOT

Y/N Table Edit

69 SAD_DIS_LETTERLINK Character(1) VARCHAR2(1) NOT NULL SAD_DIS_LETTERLINK

Y/N Table Edit

70 SAD_DIS_FALINK Character(1) VARCHAR2(1) NOT NULL SAD_DIS_FALINK

Y/N Table Edit

71 SAD_DIS_ALTCONTACT Character(1) VARCHAR2(1) NOT NULL SAD_DIS_ALTCONTACT

Y/N Table Edit

72 SAD_DEFAULTMSG Character(3) VARCHAR2(3) NOT NULL SAD_DEFAULTMSG

Prompt Table: SAD_SSTEXT_VW