DATA_CATEGORYA=Activity
B=Balance
G=General
M=Metrics
U=User
DATA_ITEM_IDLANGUAGE_CDCUST_CDITEM_LVW(SQL View) |
Index Back |
|---|---|
Customer Data ItemCustomer Data Item |
| SELECT I.DATA_CATEGORY , L.DATA_ITEM_ID , L.LANGUAGE_CD , L.AR_DESCR FROM PS_CUST_DITEM_LNG L , PS_CUST_DATA_ITEM I WHERE L.DATA_ITEM_ID = I.DATA_ITEM_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DATA_CATEGORY |
Character(1) | VARCHAR2(1) NOT NULL |
Data Item Category
A=Activity B=Balance G=General M=Metrics U=User |
| 2 | DATA_ITEM_ID |
Character(8) | VARCHAR2(8) NOT NULL | Data Item ID |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | AR_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |