TL_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 | Character(3) | VARCHAR2(3) NOT NULL | Language Code | |
3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |