FT_RUN_ID00=Not Processed
10=Loaded from File
20=Transformed
30=Previewed
40=Manually Posted
50=Posted
FT_CWB_ASGN_VW(SQL View) |
Index Back |
|---|---|
View used for Fusion Coex CWBView used for Fusion Coexistence Compensation WorkBench |
| SELECT A.FT_RUN_ID , A.FT_PROC_STATUS , A.FT_PERIOD_START_DT , A.FT_PERIOD_END_DT , A.FT_PERIOD_NAME FROM %Table(FT_CWBOBJ_HDR) A WHERE A.FT_OBJECT_IDENT = '1000' |
| # | 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_PROC_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Process Status
00=Not Processed 10=Loaded from File 20=Transformed 30=Previewed 40=Manually Posted 50=Posted |
| 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 |