SSR_IAM_REQUEST(SQL Table) |
Index Back |
---|---|
IAM Enrollment RequestIAM Enrollment Request |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SSR_IAM_REQUEST_ID | Character(10) | VARCHAR2(10) NOT NULL |
IAM Enrollment Request ID
Default Value: 0 |
2 | SSR_IAM_REQ_SEQ | Number(6,0) | INTEGER NOT NULL | IAM Request Detail Sequence |
3 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PEOPLE_SRCH |
4 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INSTITUTION_TBL |
5 | ACAD_CAREER | Character(4) | VARCHAR2(4) NOT NULL |
Academic Career
BAC=Bachelor (NLD) BBL=Vocational Coaching (NLD) BOL=Vocational Training (NLD) BUSN=Graduate Business CNED=Continuing Education CRED=Semester Credit EDU=Education (NLD) EXED=Extended Education GRAD=Graduate LAW=Law MEDS=Medical School NONA=Non Award PGRD=Postgraduate RSCH=Research TECH=Technical UENG=Undergraduate Engineering UGRD=Undergraduate VAVO=Advanced General Educ. (NLD) VETM=Veterinary Medicine |
6 | SSR_ACTIVITY_ID | Character(11) | VARCHAR2(11) NOT NULL |
Academic Activity ID
Prompt Table: SSR_ACTIVITY |
7 | SSR_ACT_ID_SEQ_NBR | Number(4,0) | SMALLINT NOT NULL | Activity ID Sequence Number |
8 | SSR_ACT_ID_ROOT | Character(11) | VARCHAR2(11) NOT NULL |
Course Root Activity ID
Prompt Table: SSR_ACT_ROOTEXT |
9 | SSR_ACTIVTY_ID_PAR | Character(11) | VARCHAR2(11) NOT NULL | Parent Activity ID |
10 | SSR_ACT_PAR_SQ_NBR | Number(4,0) | SMALLINT NOT NULL | Parent Activity ID Seq NBR |
11 | SSR_ACTIVTY_ID_ORG | Character(11) | VARCHAR2(11) NOT NULL | Original Parent Activity ID |
12 | SSR_ACT_ORG_SQ_NBR | Number(4,0) | SMALLINT NOT NULL | Original Activity ID Seq NBR |
13 | SSR_IAM_REQ_ACTION | Character(3) | VARCHAR2(3) NOT NULL |
Request Action
ACT=Activate ADD=Add CHG=Field Change CON=Confirm CRE=Create DEL=Delete INA=Inactivate REM=Remove RST=Resit SEL=Select STA=Status Change SYN=Synchronize |
14 | ENRL_REQ_DETL_STAT | Character(1) | VARCHAR2(1) NOT NULL |
Enrollment Req Detail Status
E=Errors found M=Success/Messages P=Pending S=Success X=Pending Default Value: P |
15 | SSR_IAM_ACT_SOURCE | Character(3) | VARCHAR2(3) NOT NULL |
Enrollment Source
A=Admin AM=Activity Management Sync APT=Batch APT B=Batch BLK=Block Process RST=Resit Evaluation SE=Batch Student Enroll SS=Self Service |
16 | SSR_USE_MANUAL_SEL | Character(1) | VARCHAR2(1) NOT NULL |
This field is used as a Y/N flag for deciding if classes can be manually entered for the class pop select.
Y/N Table Edit Default Value: N |
17 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
18 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
19 | SSR_IAM_BLK_ERROPT | Character(1) | VARCHAR2(1) NOT NULL |
Transaction Violation Action
E=Error R=Remove previous selection S=Select to satisfy |
20 | SSR_AM_LSTTXN_DTTM | DateTime(26) | TIMESTAMP | Last Change Transaction DTTM |
21 | SSR_IAM_RECALC_REQ | Character(1) | VARCHAR2(1) NOT NULL |
Recalculation Required
Y/N Table Edit Default Value: N |
22 | SSR_AC_CONTX_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Academic Content Context Type
CRSE=Coursework Default Value: CRSE |
23 | SSR_AC_CONTENT_TP | Character(20) | VARCHAR2(20) NOT NULL | Academic Content Type |
24 | SSR_IAM_ACT_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Activity Status
A=Assigned AC=Assigned - confirmed AX=Assigned - requires confirmtn D=Dropped E=Enrolled EC=Enrolled - Confirmed ED=Enrolled by Default EE=Enrolled EX=Enrolled - Confirmation Req'd RA=Resit Allowed RC=Resit Candidate RD=Resit Delete RN=Resit Not Allowed RR=Reassessed RS=Resit Select S=Selected SC=Selected - confirmed SD=Selected by Default SR=Selected as Resit SX=Selected - requires confirmatn WD=Withdrawn WL=Waitlisted X=Inactive |
25 | SSR_IAM_ACT_STATNW | Character(2) | VARCHAR2(2) NOT NULL | Resit Activity Status |
26 | SSR_ACTIVITY_ID_RS | Character(11) | VARCHAR2(11) NOT NULL | Supplemental Activity |
27 | SSR_ACT_RST_SQ_NBR | Number(4,0) | SMALLINT NOT NULL | Resit Attempt Number |
28 | SSR_SUP_RESIT | Character(1) | VARCHAR2(1) NOT NULL |
This field indicates if resits are allowed.
Y/N Table Edit Default Value: N |
29 | SCC_ROW_ADD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Created By |
30 | SCC_ROW_ADD_DTTM | DateTime(26) | TIMESTAMP | Created |
31 | SCC_ROW_UPD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Updated By |
32 | SCC_ROW_UPD_DTTM | DateTime(26) | TIMESTAMP | Last Update Date/Time |