SSR_APT_REQUEST_IDEA=Enroll - Add
ED=Enroll - Drop
EE=Enroll - Edit
EN=Enroll
ES=Enroll - Swap
SA=Shopcart - Add
SB=Schedule Builder
SR=Shopcart - Remove
SV=Shopcart - Validate
A=Active
I=Inactive
SSR_APT_REQXREF(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SSR_APT_REQUEST_ID |
Character(12) | VARCHAR2(12) NOT NULL | APT Request ID |
| 2 | SSR_APT_ITEM_SEQ | Number(6,0) | INTEGER NOT NULL | APT Item Seq |
| 3 | ATTEMPT_NBR | Number(3,0) | SMALLINT NOT NULL | Attempt Nbr |
| 4 | SSR_APT_PRCS_MODE | Character(2) | VARCHAR2(2) NOT NULL |
Process mode
EA=Enroll - Add ED=Enroll - Drop EE=Enroll - Edit EN=Enroll ES=Enroll - Swap SA=Shopcart - Add SB=Schedule Builder SR=Shopcart - Remove SV=Shopcart - Validate |
| 5 | STRM | Character(4) | VARCHAR2(4) NOT NULL | Term |
| 6 | CRSE_ID | Character(6) | VARCHAR2(6) NOT NULL | Course ID |
| 7 | CRSE_OFFER_NBR | Number(2,0) | SMALLINT NOT NULL | Course Offering Nbr |
| 8 | CLASS_NBR | Number(5,0) | INTEGER NOT NULL | Class Nbr |
| 9 | ENRL_REQUEST_ID | Character(10) | VARCHAR2(10) NOT NULL | Enrollment Request ID |
| 10 | ENRL_REQ_DETL_SEQ | Number(6,0) | INTEGER NOT NULL | Enrollment Req Detail Sequence |
| 11 | STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status Indicator
A=Active I=Inactive |
| 12 | SCC_ROW_ADD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Created By |
| 13 | SCC_ROW_ADD_DTTM | DateTime(26) | TIMESTAMP | Created |
| 14 | SCC_ROW_UPD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Updated By |
| 15 | SCC_ROW_UPD_DTTM | DateTime(26) | TIMESTAMP | Last Update Date/Time |