TL_PROJ_CATV2_L(SQL View) |
Index Back |
---|---|
Project Type Cat Prompt Tbl |
SELECT A.SETID , A.RESOURCE_TYPE , A.RESOURCE_CATEGORY , A.LANGUAGE_CD , B.EFFDT , B.DESCR , A.DESCR FROM PS_PROJ_TYP_CAT_LG A , PS_PROJ_CATG_LANG B WHERE A.SETID = B.SETID AND A.RESOURCE_CATEGORY = B.RESOURCE_CATEGORY AND A.LANGUAGE_CD = B.LANGUAGE_CD |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(5) | VARCHAR2(5) NOT NULL | Resource SetID | |
2 | Character(5) | VARCHAR2(5) NOT NULL |
Resource Type
Prompt Table: TL_PROJ_RTYPE_L |
|
3 | Character(5) | VARCHAR2(5) NOT NULL |
Resource Category
Prompt Table: TL_PROJ_CATVW_L |
|
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 | RELATE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Relationship Description |