SSR_AM_UPD_AET(SQL Table) |
Index Back |
|---|---|
AM UpdateThis record is the run control header record for the AM Status Update process. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | SSR_AC_CONTX_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Academic Content Context Type
CRSE=Coursework Default Value: CRSE |
| 5 | SSR_AM_RUN_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Run Type
C=Create and Process Requests E=Process Existing Requests O=Create Requests Default Value: C |
| 6 | SSR_AM_REQ_ACTION | Character(3) | VARCHAR2(3) NOT NULL |
Requested Action
STA=Status Updates Default Value: STA |
| 7 | SSR_AM_REQUEST_ID | Character(10) | VARCHAR2(10) NOT NULL | AM Request ID |
| 8 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL |
| 9 | STRM | Character(4) | VARCHAR2(4) NOT NULL |
Term
Prompt Table: TERM_VAL_TBL |
| 10 | SSR_PERIOD_ID | Character(12) | VARCHAR2(12) NOT NULL |
Academic Period ID
Prompt Table: SSR_EXAM_PRD_VW |
| 11 | SSR_AM_SEL_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Activity Selection Type
F=Use Filter M=Use Manual List |
| 12 | SSR_AC_MAX_SRCH | Number(3,0) | SMALLINT NOT NULL |
Maximum Rows Returned
Default Value: 100 |
| 13 | SSR_COUNTER | Number(9,0) | DECIMAL(9) NOT NULL | This field is used by the view to create the SR enrollment cubes |