SSR_SCRTY_GRLNV(SQL View) |
Index Back |
---|---|
OprID Access to Transcript TypSecurity table for Transcript Types |
SELECT B.OPRID ,B.INSTITUTION ,A.SSR_GRAD_STATUS ,A1.LANGUAGE_CD ,A.EFFDT ,A1.DESCR ,A1.DESCRSHORT FROM PS_SSR_GRADSTATTBL A , PS_SSR_GRADSTATLNG A1 ,PS_SSR_SCRTY_GRSTA B WHERE A.SSR_GRAD_STATUS = A1.SSR_GRAD_STATUS AND A.EFFDT = A1.EFFDT AND B.ACCESS_CD = 'Y' AND (B.SSR_GRAD_STATUS = A.SSR_GRAD_STATUS OR B.SSR_GRAD_STATUS = 'ALL') |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: OPRDEFN2 |
|
2 | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: SCRTY_TBL_INST |
|
3 | Character(4) | VARCHAR2(4) NOT NULL |
eLearning Status which is used to derive the INTERNET field on SDR Course Register File
Prompt Table: SSR_GRADSTATTBL |
|
4 | Character(3) | VARCHAR2(3) NOT NULL | Language Code | |
5 | Date(10) | DATE |
Effective Date
Default Value: %date |
|
6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
7 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |