FT_CWBOBJ_HDR

(SQL Table)

# 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_OBJECT_IDENT Character(4) VARCHAR2(4) NOT NULL A unique value to identify each objects. Use the following ranges, 0000-0999 outbound 1000-1999 inbound

3 FT_PLAN_GUID Character(36) VARCHAR2(36) NOT NULL Plan ID

4 FT_PERIOD_GUID Character(36) VARCHAR2(36) NOT NULL Period ID

5 FT_BUS_GROUP_ID Number(18,0) DECIMAL(18) NOT NULL Business Group ID

6 FT_PLAN_NAME Character(240) VARCHAR2(240) NOT NULL Plan Name

7 FT_PLAN_DESCR Long Character(4000) CLOB Description

8 FT_PERIOD_START_DT Date(10) DATE Period Start Date

9 FT_PERIOD_END_DT Date(10) DATE Period End Date

10 FT_PERIOD_NAME Character(240) VARCHAR2(240) NOT NULL Period Name

11 FT_RUN_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

12 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

13 FT_ERROR_FLAG Character(1) VARCHAR2(1) NOT NULL Error Flag
N=No
Y=Yes

14 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

15 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	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_OBJECT_IDENT	Character(4)	VARCHAR2(4) NOT NULL	A unique value to identify each objects. Use the following ranges, 0000-0999 outbound 1000-1999 inbound
3	FT_PLAN_GUID	Character(36)	VARCHAR2(36) NOT NULL	Plan ID
4	FT_PERIOD_GUID	Character(36)	VARCHAR2(36) NOT NULL	Period ID
5	FT_BUS_GROUP_ID	Number(18,0)	DECIMAL(18) NOT NULL	Business Group ID
6	FT_PLAN_NAME	Character(240)	VARCHAR2(240) NOT NULL	Plan Name
7	FT_PLAN_DESCR	Long Character(4000)	CLOB	Description
8	FT_PERIOD_START_DT	Date(10)	DATE	Period Start Date
9	FT_PERIOD_END_DT	Date(10)	DATE	Period End Date
10	FT_PERIOD_NAME	Character(240)	VARCHAR2(240) NOT NULL	Period Name
11	FT_RUN_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
12	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
13	FT_ERROR_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Error Flag N=No Y=Yes
14	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
15	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.