| # |
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 |
EFFDT_USED |
Date(10) |
DATE |
Date driving 'processed' code
|
| 4 |
FILE_INPUT |
Character(254) |
VARCHAR2(254) NOT NULL |
Test Score File Name and Path
|
| 5 |
POST_REC_SELECTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Single Record
Y/N Table Edit
Default Value: N
|
| 6 |
SRCH_MTCH_PST_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Search/Match/Post Process Optn
B=Search, Match and Post
P=Post Only
S=Search and Match Only
Default Value: B
|
| 7 |
TEST_REC_NBR |
Number(9,0) |
DECIMAL(9) NOT NULL |
Test Type Record Nbr
Prompt Table:
EDITTABLE_VW
|
| 8 |
DATA_SOURCE_RCVD |
Character(3) |
VARCHAR2(3) NOT NULL |
This field is used in as an operator default field in the record OPR_DEF_TBL_CS and prompt values are set to the same values as the field DATA_SOURCE and is used in the record EXT_ACAD_DATA for operator default values.
Default Value: ETS
Prompt Table:
XL_DATA_SRCE_VW
|
| 9 |
ADDRESS_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Type
Default Value: HOME
Prompt Table:
HCR_ADDR_TYP_I
|
| 10 |
PURGE_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Purge Option
A=All Suspense Rows
M=Marked Suspense Rows
Default Value: M
|
| 11 |
PURGE_MSGS_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Purge Messages
A=All Messages
M=Remove Associated Messages
N=Retain Associated Messages
Default Value: N
|
| 12 |
INSTITUTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table:
INSTITUTN_SCRTY
|
| 13 |
ACTION_DT |
Date(10) |
DATE |
Action Date
Default Value: %date
|
| 14 |
ADMIT_TERM |
Character(4) |
VARCHAR2(4) NOT NULL |
Admit Term
Prompt Table:
TERM_VAL_TBL
|
| 15 |
ADMIT_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Admit Type
Prompt Table:
ADMIT_TYPE_TBL
|
| 16 |
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
|
| 17 |
ACAD_PLAN |
Character(10) |
VARCHAR2(10) NOT NULL |
Academic Plan
Prompt Table:
ACAD_PLAN_TBL
|
| 18 |
EXT_ORG_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
External Org ID
Prompt Table:
EXT_ORG_TBL
|
| 19 |
ADM_APPL_CTR |
Character(4) |
VARCHAR2(4) NOT NULL |
Application Center
Prompt Table:
ADM_APPLCTR_TBL
|
| 20 |
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
Default Value: APPL
Prompt Table:
ADM_ACTION_SCTY
|
| 21 |
PROG_REASON |
Character(4) |
VARCHAR2(4) NOT NULL |
Action Reason
Prompt Table:
PROG_RSN_TBL
Set Control Field: INSTITUTION
|
| 22 |
SAD_PRA_W_CBAP_NLD |
Character(4) |
VARCHAR2(4) NOT NULL |
Withdrawal program action
Default Value: WADM
Prompt Table:
ADM_ACTION_SCTY
|
| 23 |
SAD_RA_W_CBAP_NLD |
Character(4) |
VARCHAR2(4) NOT NULL |
Withdrawal action reason
ADRV=Admission Revocation
DENY=Deny
WADM=Administrative Withdrawal
WAIT=Waitlist
WAPP=Applicant Withdrawal
Prompt Table:
SAD_PROG_RSN_VW
Set Control Field: INSTITUTION
|
| 24 |
FILE_PATH |
Character(127) |
VARCHAR2(127) NOT NULL |
Input/Output file path
|
| 25 |
SCC_BRINCD_NLD |
Character(4) |
VARCHAR2(4) NOT NULL |
BRINcode
Prompt Table:
SCC_BRINCD_NLD
|