| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SSR_ITEM_TYPE |
Character(20) |
VARCHAR2(20) NOT NULL |
Academic Item Type
|
| 2 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 3 |
DESCR20 |
Character(20) |
VARCHAR2(20) NOT NULL |
Description
|
| 4 |
SSR_ITEM_LVL |
Number(4,0) |
SMALLINT NOT NULL |
Item Order
|
| 5 |
SYSTEM_DATA_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
This Y/ N field is used to identify which rows in a table are considered SYSTEM DATA.
Y/N Table Edit
Default Value: N
|
| 6 |
SSR_PROG_NODE_FL |
Character(1) |
VARCHAR2(1) NOT NULL |
Program Format Tree Node
Y/N Table Edit
Default Value: N
|
| 7 |
SSR_GRADE_ITEM_FL |
Character(1) |
VARCHAR2(1) NOT NULL |
Grading Item Type
Y/N Table Edit
Default Value: N
|
| 8 |
SSR_HAS_DEGREE |
Character(1) |
VARCHAR2(1) NOT NULL |
Degree
Y/N Table Edit
Default Value: N
|
| 9 |
SSR_HAS_RULES |
Character(1) |
VARCHAR2(1) NOT NULL |
Rules
Y/N Table Edit
Default Value: N
|
| 10 |
SSR_HAS_INSTRCTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Instructions
Y/N Table Edit
Default Value: N
|
| 11 |
SSR_HAS_PARMS |
Character(1) |
VARCHAR2(1) NOT NULL |
Item Parameters
Y/N Table Edit
Default Value: N
|
| 12 |
SSR_HAS_ITEMS |
Character(1) |
VARCHAR2(1) NOT NULL |
Child Academic Items
Y/N Table Edit
Default Value: N
|
| 13 |
SSR_SHOW_CONNS |
Character(1) |
VARCHAR2(1) NOT NULL |
Show Connectors
Y/N Table Edit
Default Value: N
|
| 14 |
SSR_PARENT_FIRST |
Character(1) |
VARCHAR2(1) NOT NULL |
Add parent before children
Y/N Table Edit
Default Value: N
|
| 15 |
SSR_HAS_GRD_ITEMS |
Character(1) |
VARCHAR2(1) NOT NULL |
Child Grading Items
Y/N Table Edit
Default Value: N
|
| 16 |
SSR_HAS_RESULTS |
Character(1) |
VARCHAR2(1) NOT NULL |
Results
Y/N Table Edit
Default Value: N
|
| 17 |
SSR_HAS_ENRL_CAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Requires Enrollment Category
Y/N Table Edit
Default Value: N
|
| 18 |
SSR_HAS_CREDITS |
Character(1) |
VARCHAR2(1) NOT NULL |
Credits
Y/N Table Edit
Default Value: N
|
| 19 |
SSR_RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Extension Record
Prompt Table:
SSR_AIR_EXTREC
|
| 20 |
SSR_AC_CONTX_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Academic Content Context Type
CRSE=Coursework
|
| 21 |
SSR_AC_CONTENT_TP |
Character(20) |
VARCHAR2(20) NOT NULL |
Academic Content Type
Prompt Table:
SSR_AC_ITEMTYPE
|
| 22 |
SCC_ENTITY_ID |
Character(40) |
VARCHAR2(40) NOT NULL |
Entitiy ID
|
| 23 |
SSR_APT_ENTITY_ID |
Character(40) |
VARCHAR2(40) NOT NULL |
APT Entity
|
| 24 |
SCC_ROW_ADD_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Created By
|
| 25 |
SCC_ROW_ADD_DTTM |
DateTime(26) |
TIMESTAMP |
Created
|
| 26 |
SCC_ROW_UPD_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Updated By
|
| 27 |
SCC_ROW_UPD_DTTM |
DateTime(26) |
TIMESTAMP |
Last Update Date/Time
|