LANGUAGE_CDTL_RULE_PRD_LV(SQL View) |
Index Back |
|---|---|
TL Rule Period View Rel LangThis view is the related language record for TL_RULE_PRD_VW. |
| SELECT TP.PERIOD_ID , TPL.LANGUAGE_CD , TPL.DESCR FROM PS_TL_TIME_PERIODS TP , PS_TL_CALENDAR TLC , PS_TL_TIME_PER_LAN TPL WHERE TP.PERIOD_ID = TLC.PERIOD_ID AND TP.PERIOD_ID = TPL.PERIOD_ID AND TP.PERIOD_TYPE <> 'CO' AND TP.OFFSET_DAYS >= 0 AND TLC.PERIOD_SEQUENCE = 1 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PERIOD_ID | Character(12) | VARCHAR2(12) NOT NULL | Time Period ID |
| 2 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |