CNTRCT_STYLELANGUAGE_CDCNT_STYPRO_LVW(SQL View) |
Index Back |
|---|---|
Active Contract Style Lang VW02/05/2022 SAGAKULK - Active Contract Style Lang VW |
| SELECT A.CNTRCT_STYLE , B.LANGUAGE_CD , B.CNTRCT_STYLE_NAME , B.DESCR50 FROM PS_CNTRCT_STYLE A , PS_CNTRCT_STL_LNG B WHERE A.STYLE_STATUS = 'A' AND A.CNTRCT_PROC_OPT <> ' ' AND A.CNTRCT_STYLE = B.CNTRCT_STYLE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CNTRCT_STYLE |
Character(10) | VARCHAR2(10) NOT NULL | Style ID |
| 2 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 3 | CNTRCT_STYLE_NAME | Character(30) | VARCHAR2(30) NOT NULL | Contract Style |
| 4 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |