BUSINESS_UNIT_GLLM_PROJECT_IDLANGUAGE_CDLM_PROJECT_LVW(SQL View) |
Index Back |
|---|---|
Active Project ValuesContains the Active Project Chart Field Values |
| SELECT A.BUSINESS_UNIT_GL , A.LM_PROJECT_ID , B.LANGUAGE_CD , B.LM_CF_PROJ_DESCR , B.LM_CF_PROJ_SDESCR FROM PS_LM_CF_PROJECT A , PS_LM_PROJECT_LANG B WHERE A.BUSINESS_UNIT_GL = B.BUSINESS_UNIT_GL AND A.LM_PROJECT_ID = B.LM_PROJECT_ID AND LM_ACTIVE = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT_GL |
Character(5) | VARCHAR2(5) NOT NULL | General Ledger Business Unit |
| 2 | LM_PROJECT_ID |
Character(20) | VARCHAR2(20) NOT NULL | Project Chart Field |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | LM_CF_PROJ_DESCR | Character(50) | VARCHAR2(50) NOT NULL | Project Chart Field Description |
| 5 | LM_CF_PROJ_SDESCR | Character(10) | VARCHAR2(10) NOT NULL | Project Chart Field Short Description |