| # |
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 |
POST_REC_SELECTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Single Record
Y/N Table Edit
Default Value: N
|
| 4 |
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
|
| 5 |
TRANS_CNTRL_NBR |
Character(9) |
VARCHAR2(9) NOT NULL |
Transaction Set Control Number
Prompt Table:
%EDITTABLE
|
| 6 |
PURGE_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Purge Option
A=All Suspense Rows
M=Marked Suspense Rows
Default Value: M
|
| 7 |
SAD_PURGE_P_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Purge Option for Marked Rows
A=All Marked Suspense Rows
L=Rows Loaded before or on
P=Rows Posted before or on
|
| 8 |
DATE_POSTED |
Date(10) |
DATE |
Date Posted
|
| 9 |
DATE_LOADED |
Date(10) |
DATE |
Date Loaded
|
| 10 |
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
|
| 11 |
NAME_PREFIX_M |
Character(4) |
VARCHAR2(4) NOT NULL |
Male Name Prefix
Prompt Table:
NAME_PREFIX_TBL
|
| 12 |
NAME_PREFIX_F |
Character(4) |
VARCHAR2(4) NOT NULL |
Female Name Prefix
Prompt Table:
NAME_PREFIX_TBL
|
| 13 |
NAME_PREFIX_U |
Character(4) |
VARCHAR2(4) NOT NULL |
Unknown Name Prefix
Prompt Table:
NAME_PREFIX_TBL
|
| 14 |
LS_DATA_SOURCE |
Character(3) |
VARCHAR2(3) NOT NULL |
Data Source
A8=TEAS Degree Information
AAD=AADSAS
ACT=American College Testing
AE=Ad-Hoc Employee
AMC=AMCAS
AO=Ad-Hoc Organizational
E=Extract
ETS=Educational Testing Service
GH=OLSAS Last Secondary-G2
LSD=LSDAS
PI=Prev/Post Secondary Info
RS=OLSAS Postsecondary Info
SCH=School
SLF=Self-Reported Information
WWW=World Wide Web
Default Value: SCH
|
| 15 |
INSTITUTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table:
INSTITUTION_TBL
|
| 16 |
GRADING_SCHEME |
Character(3) |
VARCHAR2(3) NOT NULL |
Grading Scheme
Prompt Table:
GRADESCHEME_TBL
Set Control Field: INSTITUTION
|
| 17 |
ADM_CREATE_ACK |
Character(1) |
VARCHAR2(1) NOT NULL |
Create Acknowledgement (TS131)
Y/N Table Edit
Default Value: N
|
| 18 |
FILENAME |
Character(80) |
VARCHAR2(80) NOT NULL |
File Name
|
| 19 |
REG_REGION |
Character(5) |
VARCHAR2(5) NOT NULL |
Regulatory Region
Prompt Table:
REG_REGION_TBL
|