EMPLIDINSTITUTIONSSR_APT_INSTANCESSR_APT_ITEM_SEQATTEMPT_NBRSSR_SEQ_NBRSSR_IAMAPT_ENRL(SQL View) |
Index Back |
|---|---|
APT Item Attempt |
| SELECT B.EMPLID ,B.INSTITUTION ,B.SSR_APT_INSTANCE ,B.SSR_APT_ITEM_SEQ ,B.ATTEMPT_NBR ,B.SSR_SEQ_NBR ,A.SSR_ITEM_ID ,E.CRSE_ID ,E.CRSE_OFFER_NBR ,E.CRS_TOPIC_ID ,E.CLASS_NBR ,B.SRC_TERM FROM PS_SSR_APT_ITEM A , PS_SSR_APT_ENRL B , PS_CLASS_TBL E WHERE B.EMPLID = A.EMPLID AND B.INSTITUTION = A.INSTITUTION AND B.SSR_APT_INSTANCE = A.SSR_APT_INSTANCE AND B.SSR_APT_ITEM_SEQ = A.SSR_APT_ITEM_SEQ AND E.STRM = B.SRC_TERM AND E.CLASS_NBR = B.CLASS_NBR AND E.INSTITUTION = A.INSTITUTION AND E.CLASS_TYPE = 'E' |
| # | 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_SEQ_NBR |
Number(4,0) | SMALLINT NOT NULL | Sequence Number |
| 7 | SSR_ITEM_ID | Character(11) | VARCHAR2(11) NOT NULL | Academic Item ID |
| 8 | CRSE_ID | Character(6) | VARCHAR2(6) NOT NULL | Course ID |
| 9 | CRSE_OFFER_NBR | Number(2,0) | SMALLINT NOT NULL | Course Offering Nbr |
| 10 | CRS_TOPIC_ID | Number(3,0) | SMALLINT NOT NULL | Course Topic ID |
| 11 | CLASS_NBR | Number(5,0) | INTEGER NOT NULL | Class Nbr |
| 12 | SRC_TERM | Character(4) | VARCHAR2(4) NOT NULL | Source Term |