SSR_ITEMRSLT_VW(SQL View) |
Index Back |
|---|
| SELECT a.SSR_ITEM_TYPE , a.DESCR , a.DESCR20 , a.SSR_ITEM_LVL , a.SYSTEM_DATA_FLG , a.SSR_PROG_NODE_FL , a.SSR_GRADE_ITEM_FL , a.SSR_HAS_DEGREE , a.SSR_HAS_RULES , a.SSR_HAS_ITEMS , a.SSR_SHOW_CONNS , a.SSR_HAS_GRD_ITEMS , a.SSR_HAS_RESULTS , a.SSR_HAS_ENRL_CAT , a.SSR_AC_CONTX_TYPE , a.SSR_AC_CONTENT_TP , a.SSR_RECNAME FROM PS_SSR_ITEM_TYPE a WHERE a.SSR_HAS_RESULTS = 'Y' |
| # | 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_ITEMS | Character(1) | VARCHAR2(1) NOT NULL |
Child Academic Items
Y/N Table Edit Default Value: N |
| 11 | SSR_SHOW_CONNS | Character(1) | VARCHAR2(1) NOT NULL |
Show Connectors
Y/N Table Edit Default Value: N |
| 12 | SSR_HAS_GRD_ITEMS | Character(1) | VARCHAR2(1) NOT NULL |
Child Grading Items
Y/N Table Edit Default Value: N |
| 13 | SSR_HAS_RESULTS | Character(1) | VARCHAR2(1) NOT NULL |
Results
Y/N Table Edit |
| 14 | SSR_HAS_ENRL_CAT | Character(1) | VARCHAR2(1) NOT NULL | Requires Enrollment Category |
| 15 | SSR_AC_CONTX_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Academic Content Context Type
CRSE=Coursework |
| 16 | SSR_AC_CONTENT_TP | Character(20) | VARCHAR2(20) NOT NULL |
Academic Content Type
Prompt Table: SSR_AC_ITEMTYPE |
| 17 | SSR_RECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Extension Record
Prompt Table: SSR_AIR_EXTREC |