| # |
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 |
TEST_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Test ID
Prompt Table:
SAD_TST_SCTY_VW
|
| 4 |
POST_REC_SELECTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Single Record
Y/N Table Edit
Default Value: N
|
| 5 |
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
|
| 6 |
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
|
| 7 |
TEST_REC_NBR |
Number(9,0) |
DECIMAL(9) NOT NULL |
Test Type Record Nbr
Prompt Table:
%EDITTABLE
|
| 8 |
ADDRESS_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Type
Prompt Table:
ADDRESS_TYP_TBL
|
| 9 |
PHONE_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Phone Type
BUSN=Business
CAMP=Campus
CELL=Mobile
DORM=Dormitory
FAX=FAX
HOME=Home
MAIN=Main
OTR=Other
PGR1=Pager 1
PGR2=Pager 2
TELX=Telex
WORK=Work
|
| 10 |
EMAIL_ADDR_POP |
Character(1) |
VARCHAR2(1) NOT NULL |
Populate Email Address
Y/N Table Edit
Default Value: N
|
| 11 |
E_ADDR_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Email Address Type.
Note: Dorm long name has been updated as Dormitory as part of PI26 updates. And, the owner id of the field is updated to CC from HR.
BUSN=Business
CAMP=Campus
DORM=Dormitory
HOME=Home
OTHR=Other
|
| 12 |
COMMIT_FREQ |
Number(7,0) |
INTEGER NOT NULL |
Commit Frequency
Default Value: 1000
|
| 13 |
TEST_SELECT_LSAC |
Character(1) |
VARCHAR2(1) NOT NULL |
LSAT/LSDAS Test Score
L=LSAT Test Score
S=LSDAS Test Score
Default Value: S
|
| 14 |
SAD_CREATE_PRS |
Character(1) |
VARCHAR2(1) NOT NULL |
Create Prospect Flag
Y/N Table Edit
Default Value: N
|
| 15 |
SAD_CRM_POST |
Character(1) |
VARCHAR2(1) NOT NULL |
PDL post to CRM flag.
1=Campus Solutions
2=Enterprise CRM
Default Value: 1
|
| 16 |
SAD_ETHNIC_PRCS_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Ethnicity process switch for test score posting.
I=Update If Not Populated
U=Update All Records
Default Value: U
|
| 17 |
SAD_HISPA_PRCS_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Update Hispanic/Latino switch for test score posting.
N=Do Not Update
U=Hispanic/Latino Populated
Default Value: U
|
| 18 |
SAD_UPD_ETH_VER |
Character(1) |
VARCHAR2(1) NOT NULL |
Update IPEDS Ethnicity Flag
A=For All Person Records Posted
N=For New Person Records Added
Default Value: A
|
| 19 |
SAD_ACT_ETH_VER |
Character(1) |
VARCHAR2(1) NOT NULL |
Update IPEDS Ethnicity Flag
A=For All Person Records Posted
D=Do Not Update
N=For New Person Records Added
Default Value: A
|
| 20 |
SAD_TST_ETHNIC_GRP |
Character(8) |
VARCHAR2(8) NOT NULL |
Ethnic group code
Prompt Table:
SAD_TST_HISP_VW
|