| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 2 |
INSTITUTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Institution
|
| 3 |
SSR_APT_INSTANCE |
Number(3,0) |
SMALLINT NOT NULL |
Academic Progress Tracker Instance Number
|
| 4 |
SSR_APT_ITEM_SEQ |
Number(6,0) |
INTEGER NOT NULL |
APT Item Seq
|
| 5 |
ATTEMPT_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Attempt Nbr
|
| 6 |
SSR_SEQ_NBR |
Number(4,0) |
SMALLINT NOT NULL |
Sequence Number
|
| 7 |
SSR_YR_OF_PROG |
Character(4) |
VARCHAR2(4) NOT NULL |
Year of Program
00=Not Set
01=01 - First Year
02=02 - Second Year
03=03 - Third Year
04=04 - Fourth Year
05=05 - Fifth Year
06=06 - Sixth Year
|
| 8 |
ACAD_YEAR |
Character(4) |
VARCHAR2(4) NOT NULL |
Academic Year
|
| 9 |
STRM |
Character(4) |
VARCHAR2(4) NOT NULL |
Term
Prompt Table:
SSR_TERM_CAT_VW
|
| 10 |
SESSION_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Session
1=Regular Academic Session
10W=10 Week
12W=Twelve Week
4W1=Four Week - First
4W2=Four Week - Second
4W3=Four Week - Third
4W4=Four Week - Fourth
6W1=Six Week - First
6W2=Six Week - Second
8W1=Eight Week - First
8W2=Eight Week - Second
A11=Medical Period 1, 4 Weeks
A12=Medical Period 1, 8 Weeks
A13=Medical Pd 1, 12 Weeks
A21=Medical Period 2, 4 Weeks
A22=Medical Period 2, 8 Weeks
A23=Medical Period 2, 12 Week
FYR=Full Year
MIN=Mini Session
OEE=Open Entry/Open Exit
SM1=Semester 1
SM2=Semester 2
Prompt Table:
SESSION_TBL_VW
|
| 11 |
START_DT |
Date(10) |
DATE |
Start Date
|
| 12 |
END_DT |
Date(10) |
DATE |
end date
|
| 13 |
SSR_PERIOD_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Academic Period ID
Prompt Table:
SSR_PERIOD_TBL
|
| 14 |
SSR_ATT_PRGRS_LVL |
Character(2) |
VARCHAR2(2) NOT NULL |
Progress Level
00=00-Newly Added
20=20-Planned
40=40-In Progress
60=60-Completed
80=80-Dropped
Default Value: 00
|
| 15 |
SSR_CR_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Credit Type
20=Enrollment
30=Exam-only Course
40=Transfer Credit - Course
60=Transfer Credit - Test
80=Transfer Credit - Other
|
| 16 |
SCC_ROW_ADD_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Created By
|
| 17 |
SCC_ROW_ADD_DTTM |
DateTime(26) |
TIMESTAMP |
Created
|
| 18 |
SCC_ROW_UPD_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Updated By
|
| 19 |
SCC_ROW_UPD_DTTM |
DateTime(26) |
TIMESTAMP |
Last Update Date/Time
|