SSR_ACM_SORT_ORDSSR_AC_INCL_TYPELANGUAGE_CDSSR_AC_INTPVWLG(SQL View) |
Index Back |
|---|---|
Activity Inclusion Language VW |
| SELECT I.SSR_ACM_SORT_ORD ,I.SSR_AC_INCL_TYPE ,L.LANGUAGE_CD ,L.DESCR FROM PS_SSR_AC_INCLTYPE I , PS_SSR_AC_INCLTLNG L WHERE I.SSR_AC_INCL_TYPE = L.SSR_AC_INCL_TYPE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SSR_ACM_SORT_ORD |
Number(4,0) | SMALLINT NOT NULL | Sort Sequence |
| 2 | SSR_AC_INCL_TYPE |
Character(10) | VARCHAR2(10) NOT NULL | Inclusion Type |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |