SSR_ACO_GEN_WK1(SQL View) |
Index Back |
|---|---|
Act Gen Work RecordAct Gen Work Record |
| SELECT 0 , 0 , ' ' , ' ' , ' ' , ' ' FROM PS_SSR_DUMMY_REC |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SSR_ACO_TREE_LVL | Number(3,0) | SMALLINT NOT NULL | Level 1 Row |
| 2 | SSR_SEQ_NBR | Number(4,0) | SMALLINT NOT NULL | Sequence Number |
| 3 | SSR_AC_CONTENT_TP | Character(20) | VARCHAR2(20) NOT NULL | Academic Content Type |
| 4 | SSR_ACTIVTY_ID_ORG | Character(11) | VARCHAR2(11) NOT NULL | Original Parent Activity ID |
| 5 | SSR_ACTIVITY_ID | Character(11) | VARCHAR2(11) NOT NULL | Academic Activity ID |
| 6 | CLASS_SECTION | Character(4) | VARCHAR2(4) NOT NULL | Class Section |