FT_CWBOBJ_HDR_V

(SQL View)

SELECT DISTINCT FT_RUN_ID ,FT_OBJECT_IDENT ,FT_PLAN_GUID ,FT_PERIOD_GUID ,FT_BUS_GROUP_ID ,FT_PLAN_NAME ,FT_PERIOD_START_DT ,FT_PERIOD_END_DT ,FT_PERIOD_NAME ,FT_PROC_STATUS ,FT_ERROR_FLAG ,LASTUPDDTTM ,LASTUPDOPRID FROM PS_FT_CWBOBJ_HDR WHERE FT_RUN_ID IN ( SELECT DISTINCT FT_RUN_ID 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_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_PERIOD_START_DT Date(10) DATE Period Start Date

8 FT_PERIOD_END_DT Date(10) DATE Period End Date

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

10 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

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

12 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.

13 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_PERIOD_START_DT	Date(10)	DATE	Period Start Date
8	FT_PERIOD_END_DT	Date(10)	DATE	Period End Date
9	FT_PERIOD_NAME	Character(240)	VARCHAR2(240) NOT NULL	Period Name
10	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
11	FT_ERROR_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Error Flag N=No Y=Yes
12	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.
13	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.