SSR_APT_ADMRQRC(SQL Table) |
Index Back |
|---|---|
APT Admin Request run controlAPT Administrative Roster request run control record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 4 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INSTITUTION_TBL |
| 5 | SSR_ITEM_ID | Character(11) | VARCHAR2(11) NOT NULL |
Academic Item ID
Prompt Table: SSR_AIR_PRG_VW |
| 6 | SSR_APT_ACTION | Character(3) | VARCHAR2(3) NOT NULL |
APT Request Action
ACT=Activate Planning Node AIT=Add Item ASE=APT Status Evaluation CAT=Create Ins & Plan Node Attempt CNA=Create Plan Node(s) CRS=Calculate Results CRT=Create Instance CSB=Create Substitution DEL=Delete Planning Node EAS=Enter APT Status ENR=Enrollment ERS=Enter Results RIT=Remove Item SHC=Shopping Cart |
| 7 | SSR_ITEM_ID_1 | Character(11) | VARCHAR2(11) NOT NULL |
Academic Item ID
Prompt Table: %EDITTABLE |
| 8 | SSR_ITEM_ID_2 | Character(11) | VARCHAR2(11) NOT NULL |
Academic Item ID
Prompt Table: %EDITTABLE2 |
| 9 | SSR_RSLT_TYPE | Character(20) | VARCHAR2(20) NOT NULL | Result Type |
| 10 | SSR_RES_MAP_ID | Character(12) | VARCHAR2(12) NOT NULL | Result Scale |
| 11 | SSR_ENRL_CAT | Character(4) | VARCHAR2(4) NOT NULL | Enrollment Category |
| 12 | SSR_DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Process Description |
| 13 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |
| 14 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 15 | DESCR50_1 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |