BUSINESS_UNIT_AMPROFILE_IDLANGUAGE_CDPROFILE_IN_VWLN(SQL View) |
Index Back |
|---|---|
Asset Profile Prompt View |
| SELECT %Substring(b.setcntrlvalue,1,5) , a.profile_id , c.language_cd , c.descr FROM PS_PROFILE_TBL a , ps_set_cntrl_rec b , ps_profile_lang c WHERE a.setid = b.setid AND a.setid = c.setid AND a.profile_id = c.profile_id AND b.recname = 'PROFILE_TBL' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT_AM |
Character(5) | VARCHAR2(5) NOT NULL | AM Business Unit |
| 2 | PROFILE_ID |
Character(10) | VARCHAR2(10) NOT NULL | Asset Profile ID |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |