PROJ_AN_GRP_LVW(SQL View) |
Index Back |
---|---|
Project Analysis Group PromptLanguage view for Project Analysis Group. |
SELECT A.SETID , A.ANALYSIS_GROUP , A.ANALYSIS_TYPE , C.LANGUAGE_CD , B.EFFDT , C.DESCR FROM PS_PROJ_AN_GRP_MAP A , PS_PROJ_ANTYPE_TBL B , PS_PROJ_ANTYPE_LNG C WHERE A.SETID = B.SETID AND A.ANALYSIS_TYPE = B.ANALYSIS_TYPE AND %Join(COMMON_KEYS, PROJ_ANTYPE_TBL B , PROJ_ANTYPE_LNG C) |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SETID_TBL |
2 | ANALYSIS_GROUP | Character(5) | VARCHAR2(5) NOT NULL |
Analysis Group
Prompt Table: SP_AN_GRP_NONVW |
3 | ANALYSIS_TYPE | Character(3) | VARCHAR2(3) NOT NULL | Analysis Type |
4 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
5 | EFFDT | Date(10) | DATE | Effective Date |
6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |