FT_CWB_BONUS_VW

(SQL View)

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 = '1002'

# 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

#	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