SSR_APT_ATT(SQL Table) |
Index Back |
|---|---|
APT Item Attempt |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 3 | SSR_APT_INSTANCE |
Number(3,0) | SMALLINT NOT NULL | Academic Progress Tracker Instance Number |
| 4 | SSR_APT_ITEM_SEQ |
Number(6,0) | INTEGER NOT NULL | APT Item Seq |
| 5 | ATTEMPT_NBR |
Number(3,0) | SMALLINT NOT NULL | Attempt Nbr |
| 6 | SSR_ATTMPT_NBR_PAR | Number(3,0) | SMALLINT NOT NULL |
Parent Attempt Nbr
Default Value: 1 |
| 7 | CRSE_ID | Character(6) | VARCHAR2(6) NOT NULL | Course ID |
| 8 | CRSE_OFFER_NBR | Number(2,0) | SMALLINT NOT NULL | Course Offering Nbr |
| 9 | CRS_TOPIC_ID | Number(3,0) | SMALLINT NOT NULL | Course Topic ID |
| 10 | SSR_CREDITS | Number(8,3) | DECIMAL(7,3) NOT NULL | Credits |
| 11 | SSR_ADVR_APPR_STAT | Character(4) | VARCHAR2(4) NOT NULL |
Advisor Approval Status
20=Not Required 40=Pending 60=Approved 80=Denied Default Value: 20 |
| 12 | SSR_ATT_OUTCOME | Character(4) | VARCHAR2(4) NOT NULL |
Attempt Outcome
20=Not Passed 40=Passed |
| 13 | SSR_RETAKE_ELIG | Character(1) | VARCHAR2(1) NOT NULL |
Eligible for Retake
N=No Y=Yes |
| 14 | SSR_ATT_STAT | Character(2) | VARCHAR2(2) NOT NULL |
Attempt Status
20=Activated 60=Provisional 80=Finalized |
| 15 | SSR_INCL_IN_CALC | Character(1) | VARCHAR2(1) NOT NULL |
Include in Calculation
Y/N Table Edit Default Value: Y |
| 16 | TSCRPT_PRINT | Character(1) | VARCHAR2(1) NOT NULL |
Print in Transcript
Y/N Table Edit Default Value: Y |
| 17 | FREEZE_REC_FL | Character(1) | VARCHAR2(1) NOT NULL |
Attempt Locked
Y/N Table Edit Default Value: N |
| 18 | SCC_ROW_ADD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Created By |
| 19 | SCC_ROW_ADD_DTTM | DateTime(26) | TIMESTAMP | Created |
| 20 | SCC_ROW_UPD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Updated By |
| 21 | SCC_ROW_UPD_DTTM | DateTime(26) | TIMESTAMP | Last Update Date/Time |
| 22 | SSR_NOTE_LONG | Long Character | CLOB | Notes |