SAD_CRS_TRCR_VW(SQL View) |
Index Back |
|---|---|
Course Transfer Credit DetailExternal Course Transfer Credit Detail |
| SELECT DISTINCT A.EMPLID ,A.EXT_ORG_ID ,A.EXT_COURSE_NBR ,B.MODEL_NBR ,B.ARTICULATION_TERM ,B.TRNSFR_STAT ,B.UNT_TAKEN ,B.CRSE_GRADE_INPUT FROM PS_EXT_COURSE A , PS_TRNS_CRSE_DTL B WHERE A.EMPLID = B.EMPLID AND A.EXT_ORG_ID = B.TRNSFR_SRC_ID AND A.EXT_COURSE_NBR = B.EXT_COURSE_NBR |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Default Value: SCC_PERS_SA_VW.EMPLID Prompt Table: PEOPLE_SRCH |
| 2 | EXT_ORG_ID |
Character(11) | VARCHAR2(11) NOT NULL |
External Org ID
Default Value: ACAD_HISTORY.EXT_ORG_ID Prompt Table: ACAD_HISTORY |
| 3 | EXT_COURSE_NBR |
Number(3,0) | SMALLINT NOT NULL | External Course Number |
| 4 | MODEL_NBR |
Number(3,0) | SMALLINT NOT NULL |
Transfer Model Nbr
Prompt Table: TRNS_CRSE_SCH |
| 5 | ARTICULATION_TERM |
Character(4) | VARCHAR2(4) NOT NULL |
Articulation Term
Prompt Table: TERM_TBL |
| 6 | TRNSFR_STAT | Character(1) | VARCHAR2(1) NOT NULL |
Transfer Status
C=Contingent Credit N=Rejected P=Posted R=No Rule Y=Accepted |
| 7 | UNT_TAKEN | Number(6,2) | DECIMAL(5,2) NOT NULL | Units Taken |
| 8 | CRSE_GRADE_INPUT | Character(3) | VARCHAR2(3) NOT NULL |
Grade Input
A=A |