| # |
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 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 3 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 4 |
SEPARATOR |
Character(1) |
VARCHAR2(1) NOT NULL |
TS130 field separator.
|
| 5 |
END_OF_LINE |
Character(1) |
VARCHAR2(1) NOT NULL |
End of Line
|
| 6 |
SUB_SEPARATOR |
Character(1) |
VARCHAR2(1) NOT NULL |
TS130 Sub Separator.
|
| 7 |
TS130_INST_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
TS130 Select school identifier
21=IPEDS Code
22=FICE Code
24=ATP Code
25=ACT Code
26=Stat Canada Postsecondary
35=Stat Canada College Student
36=Stat Canada Uni Student Inst.
ZZ=Mutually Defined
|
| 8 |
SENDER_CODE |
Character(15) |
VARCHAR2(15) NOT NULL |
Sending Institution Code
|
| 9 |
TS130_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
TS130 Status - testing or production
P=Production Data
T=Test Data
Default Value: T
|
| 10 |
TS130_REQ_ACK |
Character(1) |
VARCHAR2(1) NOT NULL |
TS130 Acknowledgement Requested
0=No Acknowledgement Requested
1=Acknowledgement Requested
Default Value: 0
|
| 11 |
TS130_RCV_INST_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
TS130 Select school identifier
21=IPEDS Code
22=FICE Code
24=ATP Code
25=ACT Code
|
| 12 |
TS130_SEND_INST_N1 |
Character(2) |
VARCHAR2(2) NOT NULL |
TS130 Select school identifier
71=IPEDS Code
72=ATP Code
73=FICE Code
74=ACT Code
78=College Board and ACT
CB=Statistics Canada College
CS=Statistics Canada University
|
| 13 |
SENDER_CODE_N1 |
Character(15) |
VARCHAR2(15) NOT NULL |
Sending Institution Code (N1)
|
| 14 |
TS130_RECV_INST_N1 |
Character(2) |
VARCHAR2(2) NOT NULL |
TS130 Select school identifier
71=IPEDS Code
72=ATP Code
73=FICE Code
74=ACT Code
|
| 15 |
USING_TS130 |
Character(1) |
VARCHAR2(1) NOT NULL |
TS130 Setup.
Y/N Table Edit
Default Value: N
|
| 16 |
TS130_PCL_INST_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
TS130 Select school identifier
71=IPEDS Code
72=ATP Code
73=FICE Code
74=ACT Code
|
| 17 |
TS130_CRS_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
TS130 Select course code
81=CIP Code
82=HEGIS Code
|
| 18 |
TS130_MIN_GPA |
Character(20) |
VARCHAR2(20) NOT NULL |
TS130 Min GPA for an Institution.
|
| 19 |
TS130_MAX_GPA |
Character(20) |
VARCHAR2(20) NOT NULL |
TS130 Max GPA for an Institution.
|
| 20 |
TS130_GRADE_QUALIF |
Character(3) |
VARCHAR2(3) NOT NULL |
TS130 Grade Qualification.
Default Value: 517
|
| 21 |
TS130_EMAIL_SUBJ |
Character(100) |
VARCHAR2(100) NOT NULL |
E-Mail Subject for TS130.
|
| 22 |
EMAIL_ADDR |
Character(70) |
VARCHAR2(70) NOT NULL |
Email Address
|
| 23 |
FILE_NAME_TS |
Character(70) |
VARCHAR2(70) NOT NULL |
File Name
|
| 24 |
FILE_PATH |
Character(127) |
VARCHAR2(127) NOT NULL |
Input/Output file path
|
| 25 |
CONTACT_CODE |
Character(2) |
VARCHAR2(2) NOT NULL |
TS130 Contact Function Code.
BP=School Principal
DN=Dental School Admission Office
E2=Evening Programs Office
FA=Financial Aid Office
GA=Graduate Fine Arts Office
GB=Graduate Business Office
GC=Guidance Counselor
GE=Graduate Engineering Office
GR=Graduate Admissions Office
LD=Law School Admissions Office
MD=Medical Admissions Office
PK=Performance Evaluation Commit.
PS=Personnel Department
RG=Registrar
SB=Student
SK=School Clerk
SP=Special Program Contact
SW=Social Services Worker
TC=College of Education Admission
TH=School of Theology Admissions
UG=Undergraduate Admissions
VM=Veterinary Medicine Admissions
|
| 26 |
NAME_AC |
Character(50) |
VARCHAR2(50) NOT NULL |
Name
|
| 27 |
FILE_NAME_TS131 |
Character(70) |
VARCHAR2(70) NOT NULL |
TS131 File Name
|