SCC_TM_CFGSVWLN(SQL View) |
Index Back |
---|---|
config search view |
SELECT D.OPRID , A.institution , A.scc_tm_task_id ,B.LANGUAGE_CD , B.ptai_label FROM %Table(SCC_TM_CONFIG) A JOIN %Table(PTAI_LIST_LNG) B ON A.SCC_TM_TASK_ID = B.PTAI_LIST_ID , PSOPRDEFN D WHERE %EffdtCheck(SCC_TM_CONFIG eff1, A, %currentdatein) AND EXISTS ( SELECT 'X' FROM PS_SCC_TM_PTAILPRV F , PSROLEUSER X WHERE F.SCC_TM_LIST_ID = A.scc_tm_task_id AND X.ROLEUSER = D.OPRID AND ((F.SCC_TM_PTAIMBRTYPE = 'USER' AND F.SCC_TM_PTAIMBRNAME = X.ROLEUSER) OR (F.SCC_TM_PTAIMBRTYPE = 'ROLE' AND F.SCC_TM_PTAIMBRNAME = X.ROLENAME)) ) |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
2 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL |
3 | SCC_TM_TASK_ID | Character(31) | VARCHAR2(31) NOT NULL |
Template ID
Prompt Table: SCC_TM_TEMPLVW |
4 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
5 | SCC_TM_LABEL | Character(100) | VARCHAR2(100) NOT NULL | Title |