FT_RUN_IDFT_CWBHDR_VW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT FT_RUN_ID ,FT_PLAN_NAME ,FT_PERIOD_START_DT ,FT_PERIOD_END_DT ,FT_PERIOD_NAME FROM PS_FT_CWBOBJ_HDR |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FT_RUN_ID |
Number(18,0) | DECIMAL(18) NOT NULL | LEGAL_ENTITY_ID |
| 2 | FT_PLAN_NAME | Character(240) | VARCHAR2(240) NOT NULL | Plan Name |
| 3 | FT_PERIOD_START_DT | Date(10) | DATE | Period Start Date |
| 4 | FT_PERIOD_END_DT | Date(10) | DATE | Period End Date |
| 5 | FT_PERIOD_NAME | Character(240) | VARCHAR2(240) NOT NULL | Period Name |