ADM_APPL_PARMS (SQL Table)	Index Back
LSAT Test Score Input Parms LSAT_PARMS holds the parameters needed for the processing of the LSAT(Law Scholastic Aptitude Test) Test Score tape.

ADM_APPL_PARMS

(SQL Table)

LSAT Test Score Input Parms

LSAT_PARMS holds the parameters needed for the processing of the LSAT(Law Scholastic Aptitude Test) Test Score tape.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

3 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
Default Value: OPR_DEF_TBL_CS.ACAD_CAREER
Prompt Table: ACAD_CAR_SCRTY

4 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table: INSTITUTN_SCRTY

5 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program
Prompt Table: ACAD_PROG_SCTY

6 ADMIT_TERM Character(4) VARCHAR2(4) NOT NULL Admit Term
Prompt Table: TERM_TBL

7 ADM_APPL_CTR Character(4) VARCHAR2(4) NOT NULL Application Center
Prompt Table: ADM_APPLCTR_SVW

8 ADMIT_TYPE Character(3) VARCHAR2(3) NOT NULL Admit Type
Prompt Table: ADMIT_TYPE_VW

9 APPL_FEE_STATUS Character(3) VARCHAR2(3) NOT NULL Application Fee Status
DEF=Deferred Payment
PEN=Pending
REC=Received
WRQ=Waiver Request
WVD=Waived
Default Value: REC

10 NOTIFICATION_PLAN Character(4) VARCHAR2(4) NOT NULL Notification Plan
ERLY=Early Admission Decision
REG=Regular Admission Decision
ROLL=Rolling Admission
Default Value: REG

11 REGION Character(10) VARCHAR2(10) NOT NULL Region
Prompt Table: REGN_BASE_SRCH

12 REGION_FROM Character(1) VARCHAR2(1) NOT NULL Region from
A=Address
O=School
R=Region Tree

13 RECRUITER_ID Character(11) VARCHAR2(11) NOT NULL Recruiter ID
Prompt Table: RECRUITERS_VW2

14 PRIMARY_FLAG Character(1) VARCHAR2(1) NOT NULL Primary Flag
N=No
Y=Yes
Y/N Table Edit
Default Value: N

15 ADM_APPL_COMPLETE Character(1) VARCHAR2(1) NOT NULL Application Complete
Y/N Table Edit
Default Value: N

16 GRADUATION_DT Date(10) DATE Graduation Date

17 APPL_FEE_TYPE Character(3) VARCHAR2(3) NOT NULL Application Fee Type
INT=International
STN=Standard
Default Value: STN

18 ADM_APPL_METHOD Character(3) VARCHAR2(3) NOT NULL Application Method
DSK=Diskette
EDI=EDI
HRD=Hard Copy
OUA=Ontario University Application
SRV=Application Service
WWW=Web Application
Default Value: OPR_DEF_TBL_CS.ADM_APPL_METHOD

19 APPL_FEE_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Application Fee Amount

20 APPL_FEE_PAID Signed Number(18,2) DECIMAL(16,2) NOT NULL Application Fee Paid

21 TENDER_CATEGORY Character(3) VARCHAR2(3) NOT NULL Tender Category
CC=Credit Card
CCI=Credit Card In
CCO=Credit Card Out
CK=Check
CKI=Check In
CKO=Check Out
CS=Cash
CSI=Cash In
CSO=Cash Out
DB=Debit Card
DBI=Debit Card In
DBO=Debit Card Out
DD=Direct Deposit
DDI=Direct Debit
DDO=Direct Deposit
EC=Electronic Check
TP=Third Party Check
TPI=Third Party Check In
WIR=Wire Transfer

22 ACADEMIC_LEVEL Character(3) VARCHAR2(3) NOT NULL Academic Level
00=Not Set
01=First Year
02=Second Year
03=Third Year
04=Fourth Year
05=Fifth Year
06=Sixth Year
10=Freshman
20=Sophomore
30=Junior
40=Senior
50=Post-Bacc Undergraduate
GR=Graduate
GRA=Graduate AUS
HON=Honours
IE=Industrial Experience
MAS=Masters
P1=Professional Year 1
P2=Professional Year 2
P3=Professional Year 3
P4=Professional Year 4
PHD=PhD
Default Value: OPR_DEF_TBL_CS.ACADEMIC_LEVEL

23 PROG_STATUS Character(4) VARCHAR2(4) NOT NULL Academic Program Status
AC=Active in Program
AD=Admitted
AP=Applicant
CM=Completed Program
CN=Cancelled
DC=Discontinued
DE=Deceased
DM=Dismissed
LA=Leave of Absence
PM=Prematriculant
SP=Suspended
WT=Waitlisted
Default Value: AP

24 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

25 PROG_REASON Character(4) VARCHAR2(4) NOT NULL Action Reason
Prompt Table: PROG_RSN_TBL

26 EXP_GRAD_TERM Character(4) VARCHAR2(4) NOT NULL Expected Graduation Term
Prompt Table: TERM_TBL

27 REQ_TERM Character(4) VARCHAR2(4) NOT NULL Requirement Term
Default Value: ADM_APPL_PARMS.ADMIT_TERM
Prompt Table: TERM_TBL

28 ACAD_LOAD_APPR Character(1) VARCHAR2(1) NOT NULL Approved Academic Load
B=Vocational Coaching (NLD)
D=Dual (NLD)
E=Part-time Vocational Tr (NLD)
F=Full-Time
O=Vocational Training (NLD)
P=Part-Time
Default Value: F

29 CAMPUS Character(5) VARCHAR2(5) NOT NULL Campus
Prompt Table: HOME_CAMPUS_VW

30 ACAD_PROG_DUAL Character(5) VARCHAR2(5) NOT NULL Dual Academic Program
Prompt Table: ACAD_PROG_TBL

31 JOINT_PROG_APPR Character(1) VARCHAR2(1) NOT NULL Joint Program Approved
Y/N Table Edit
Default Value: N

32 DECLARE_DT Date(10) DATE Declare Date
Default Value: %date

33 ACAD_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Plan
Default Value: OPR_DEF_TBL_CS.ACAD_PLAN
Prompt Table: ACAD_PLAN_SVW2

34 ACAD_SUB_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Sub-Plan
Prompt Table: ACAD_SUBPLN_TBL

35 ADM_RECR_CTR Character(4) VARCHAR2(4) NOT NULL Recruiting Center
Prompt Table: ADM_RECRCTR_SVW

36 HOUSING_INTEREST Character(1) VARCHAR2(1) NOT NULL Housing Interest
C=Commuter
F=Off Campus Housing
H=On Campus Housing

37 FIN_AID_INTEREST Character(1) VARCHAR2(1) NOT NULL Financial Aid Interest
Y/N Table Edit
Default Value: N

38 RECRUITMENT_CAT Character(4) VARCHAR2(4) NOT NULL Recruitment Category
Prompt Table: RECRUIT_CAT_VW

39 RECRUIT_SUB_CAT Character(4) VARCHAR2(4) NOT NULL Recruitment Sub-Category
HIGH=High
LOW=Low
MED=Medium

40 CREATE_TST_SCR_APP Character(1) VARCHAR2(1) NOT NULL Create Test Score Appl Data
A=ADA Test Score Data
L=LAW Test Score Data
M=MCAT Test Score Data
Default Value: L

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	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 Default Value: OPR_DEF_TBL_CS.ACAD_CAREER Prompt Table: ACAD_CAR_SCRTY
4	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTN_SCRTY
5	ACAD_PROG	Character(5)	VARCHAR2(5) NOT NULL	Academic Program Prompt Table: ACAD_PROG_SCTY
6	ADMIT_TERM	Character(4)	VARCHAR2(4) NOT NULL	Admit Term Prompt Table: TERM_TBL
7	ADM_APPL_CTR	Character(4)	VARCHAR2(4) NOT NULL	Application Center Prompt Table: ADM_APPLCTR_SVW
8	ADMIT_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Admit Type Prompt Table: ADMIT_TYPE_VW
9	APPL_FEE_STATUS	Character(3)	VARCHAR2(3) NOT NULL	Application Fee Status DEF=Deferred Payment PEN=Pending REC=Received WRQ=Waiver Request WVD=Waived Default Value: REC
10	NOTIFICATION_PLAN	Character(4)	VARCHAR2(4) NOT NULL	Notification Plan ERLY=Early Admission Decision REG=Regular Admission Decision ROLL=Rolling Admission Default Value: REG
11	REGION	Character(10)	VARCHAR2(10) NOT NULL	Region Prompt Table: REGN_BASE_SRCH
12	REGION_FROM	Character(1)	VARCHAR2(1) NOT NULL	Region from A=Address O=School R=Region Tree
13	RECRUITER_ID	Character(11)	VARCHAR2(11) NOT NULL	Recruiter ID Prompt Table: RECRUITERS_VW2
14	PRIMARY_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Primary Flag N=No Y=Yes Y/N Table Edit Default Value: N
15	ADM_APPL_COMPLETE	Character(1)	VARCHAR2(1) NOT NULL	Application Complete Y/N Table Edit Default Value: N
16	GRADUATION_DT	Date(10)	DATE	Graduation Date
17	APPL_FEE_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Application Fee Type INT=International STN=Standard Default Value: STN
18	ADM_APPL_METHOD	Character(3)	VARCHAR2(3) NOT NULL	Application Method DSK=Diskette EDI=EDI HRD=Hard Copy OUA=Ontario University Application SRV=Application Service WWW=Web Application Default Value: OPR_DEF_TBL_CS.ADM_APPL_METHOD
19	APPL_FEE_AMT	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Application Fee Amount
20	APPL_FEE_PAID	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Application Fee Paid
21	TENDER_CATEGORY	Character(3)	VARCHAR2(3) NOT NULL	Tender Category CC=Credit Card CCI=Credit Card In CCO=Credit Card Out CK=Check CKI=Check In CKO=Check Out CS=Cash CSI=Cash In CSO=Cash Out DB=Debit Card DBI=Debit Card In DBO=Debit Card Out DD=Direct Deposit DDI=Direct Debit DDO=Direct Deposit EC=Electronic Check TP=Third Party Check TPI=Third Party Check In WIR=Wire Transfer
22	ACADEMIC_LEVEL	Character(3)	VARCHAR2(3) NOT NULL	Academic Level 00=Not Set 01=First Year 02=Second Year 03=Third Year 04=Fourth Year 05=Fifth Year 06=Sixth Year 10=Freshman 20=Sophomore 30=Junior 40=Senior 50=Post-Bacc Undergraduate GR=Graduate GRA=Graduate AUS HON=Honours IE=Industrial Experience MAS=Masters P1=Professional Year 1 P2=Professional Year 2 P3=Professional Year 3 P4=Professional Year 4 PHD=PhD Default Value: OPR_DEF_TBL_CS.ACADEMIC_LEVEL
23	PROG_STATUS	Character(4)	VARCHAR2(4) NOT NULL	Academic Program Status AC=Active in Program AD=Admitted AP=Applicant CM=Completed Program CN=Cancelled DC=Discontinued DE=Deceased DM=Dismissed LA=Leave of Absence PM=Prematriculant SP=Suspended WT=Waitlisted Default Value: AP
24	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
25	PROG_REASON	Character(4)	VARCHAR2(4) NOT NULL	Action Reason Prompt Table: PROG_RSN_TBL
26	EXP_GRAD_TERM	Character(4)	VARCHAR2(4) NOT NULL	Expected Graduation Term Prompt Table: TERM_TBL
27	REQ_TERM	Character(4)	VARCHAR2(4) NOT NULL	Requirement Term Default Value: ADM_APPL_PARMS.ADMIT_TERM Prompt Table: TERM_TBL
28	ACAD_LOAD_APPR	Character(1)	VARCHAR2(1) NOT NULL	Approved Academic Load B=Vocational Coaching (NLD) D=Dual (NLD) E=Part-time Vocational Tr (NLD) F=Full-Time O=Vocational Training (NLD) P=Part-Time Default Value: F
29	CAMPUS	Character(5)	VARCHAR2(5) NOT NULL	Campus Prompt Table: HOME_CAMPUS_VW
30	ACAD_PROG_DUAL	Character(5)	VARCHAR2(5) NOT NULL	Dual Academic Program Prompt Table: ACAD_PROG_TBL
31	JOINT_PROG_APPR	Character(1)	VARCHAR2(1) NOT NULL	Joint Program Approved Y/N Table Edit Default Value: N
32	DECLARE_DT	Date(10)	DATE	Declare Date Default Value: %date
33	ACAD_PLAN	Character(10)	VARCHAR2(10) NOT NULL	Academic Plan Default Value: OPR_DEF_TBL_CS.ACAD_PLAN Prompt Table: ACAD_PLAN_SVW2
34	ACAD_SUB_PLAN	Character(10)	VARCHAR2(10) NOT NULL	Academic Sub-Plan Prompt Table: ACAD_SUBPLN_TBL
35	ADM_RECR_CTR	Character(4)	VARCHAR2(4) NOT NULL	Recruiting Center Prompt Table: ADM_RECRCTR_SVW
36	HOUSING_INTEREST	Character(1)	VARCHAR2(1) NOT NULL	Housing Interest C=Commuter F=Off Campus Housing H=On Campus Housing
37	FIN_AID_INTEREST	Character(1)	VARCHAR2(1) NOT NULL	Financial Aid Interest Y/N Table Edit Default Value: N
38	RECRUITMENT_CAT	Character(4)	VARCHAR2(4) NOT NULL	Recruitment Category Prompt Table: RECRUIT_CAT_VW
39	RECRUIT_SUB_CAT	Character(4)	VARCHAR2(4) NOT NULL	Recruitment Sub-Category HIGH=High LOW=Low MED=Medium
40	CREATE_TST_SCR_APP	Character(1)	VARCHAR2(1) NOT NULL	Create Test Score Appl Data A=ADA Test Score Data L=LAW Test Score Data M=MCAT Test Score Data Default Value: L