EMPLIDINSTITUTIONSCC_AFL_CODESTART_DTSCC_AFL_PLCD_MTDB=Batch
E=Event
M=Manual
S=System
LANGUAGE_CDPrompt Table: SCC_AFL_STS_DES
SCC_AFLHSTVW_LN(SQL View) |
Index Back |
|---|---|
Affiliation History Vw Lng RcdAffiliation History view Language Record |
| SELECT DISTINCT A.EMPLID ,A.INSTITUTION ,A.SCC_AFL_CODE ,A.START_DT ,A.SCC_AFL_PLCD_MTD ,B.LANGUAGE_CD ,B.SCC_AFL_STS_DESCR FROM PS_SCC_AFL_PERSON A ,PS_SCC_AFLPERSN_LN B WHERE A.EMPLID=B.EMPLID AND A.INSTITUTION=B.INSTITUTION AND A.SCC_AFL_CODE=B.SCC_AFL_CODE AND A.START_DT=B.START_DT |
| # | 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 | SCC_AFL_CODE |
Character(10) | VARCHAR2(10) NOT NULL | Affiliations Code |
| 4 | START_DT |
Date(10) | DATE | Start Date |
| 5 | SCC_AFL_PLCD_MTD |
Character(1) | VARCHAR2(1) NOT NULL |
Placed Method for Affiliations
B=Batch E=Event M=Manual S=System |
| 6 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 7 | SCC_AFL_STS_DESCR | Character(30) | VARCHAR2(30) NOT NULL |
Affiliation Status Description
Prompt Table: SCC_AFL_STS_DES |