SSR_IAMRTNOTELN(SQL View) |
Index Back |
---|---|
IAM Rslt Note Vw Lang by RootIAM Result Note View Language by Root |
SELECT A.EMPLID , A.INSTITUTION , A.SSR_ACT_ID_ROOTXRF , A.SSR_ACTIVITY_ID , A.SSR_ACT_ID_SEQ_NBR , A.SSR_RSLT_SEQ , L.LANGUAGE_CD , A.SSR_DESCRLONG FROM PS_SSR_IAM_RSLTNTE A , PS_SSR_IAM_RNTELNG L WHERE A.EMPLID = L.EMPLID AND A.INSTITUTION = L.INSTITUTION AND A.SSR_ACTIVITY_ID = L.SSR_ACTIVITY_ID AND A.SSR_ACT_ID_SEQ_NBR = L.SSR_ACT_ID_SEQ_NBR AND A.SSR_RSLT_SEQ = L.SSR_RSLT_SEQ |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(11) | VARCHAR2(11) NOT NULL | Employee ID | |
2 | Character(5) | VARCHAR2(5) NOT NULL | Academic Institution | |
3 | Character(11) | VARCHAR2(11) NOT NULL | Course Root Activity ID | |
4 | Character(11) | VARCHAR2(11) NOT NULL | Academic Activity ID | |
5 | Number(4,0) | SMALLINT NOT NULL |
Activity ID Sequence Number
Default Value: 1 |
|
6 | Number(3,0) | SMALLINT NOT NULL |
Result Sequence Nbr
Default Value: 1 |
|
7 | Character(3) | VARCHAR2(3) NOT NULL | Language Code | |
8 | SSR_DESCRLONG | Long Character | CLOB | Description |