| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PEOPLE_SRCH
|
| 2 |
INSTITUTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table:
INSTITUTION_TBL
|
| 3 |
AID_YEAR |
Character(4) |
VARCHAR2(4) NOT NULL |
Aid Year
Default Value: OPR_DEF_TBL_CS.AID_YEAR
Prompt Table:
AID_YEAR_TBL
|
| 4 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 5 |
ISIR_TXN_NBR |
Number(2,0) |
SMALLINT NOT NULL |
Transaction Num
|
| 6 |
ORIG_SSN |
Character(9) |
VARCHAR2(9) NOT NULL |
Original SSN
|
| 7 |
NAME_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Name Code
|
| 8 |
ASSIGNED_PIN |
Number(4,0) |
SMALLINT NOT NULL |
Unique Nbr Assigned to Student
|
| 9 |
REQUEST_ISIR |
Character(1) |
VARCHAR2(1) NOT NULL |
Request ISIR from DOE
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 10 |
SCHOOL_REPLACE_POS |
Character(1) |
VARCHAR2(1) NOT NULL |
The School You're Replacing
1=Replace School #1 w/your Inst.
2=Replace School #2 w/your Inst.
3=Replace School #3 w/your Inst.
4=Replace School #4 w/your Inst.
5=Replace School #5 w/your Inst.
6=Replace School #6 w/your Inst.
7=Replace School #7 w/your Inst.
8=Replace School #8 w/your Inst.
9=Replace School #9 w/your Inst.
A=Replace School #10 w/your Inst
Default Value: 6
|
| 11 |
REQUEST_DT |
Date(10) |
DATE |
Request Date
Default Value: %date
|
| 12 |
PROCESS_DT |
Date(10) |
DATE |
Process Date
|
| 13 |
PROCESS_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Flag
C=Complete
V=Void
X=W-2c Issued
|
| 14 |
CPS_SCHOOL_CODE |
Character(6) |
VARCHAR2(6) NOT NULL |
CPS School Code. Also known as Title IV School Code
Prompt Table:
TIV_SCHOOL_TBL
|
| 15 |
ADD_INST_PROC_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Status
C=Complete
N=New/Send
S=Sent
|