FT_HR_BUS_UNIT

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	FT_BUS_UNIT_GUID	Character(36)	VARCHAR2(36) NOT NULL	ORGANIZATION_ID GUID
3	FT_BUS_GROUP_ID	Number(18,0)	DECIMAL(18) NOT NULL	Business Group ID
4	FT_NAME	Character(240)	VARCHAR2(240) NOT NULL	Name
5	FT_SHORT_CODE	Character(30)	VARCHAR2(30) NOT NULL	ORG_INFORMATION1
6	FT_STATUS	Character(30)	VARCHAR2(30) NOT NULL	Status
7	FT_LOCATION_ID	Character(18)	VARCHAR2(18) NOT NULL	Location ID
8	FT_MANAGER_ID	Character(150)	VARCHAR2(150) NOT NULL	ORG_INFORMATION1
9	FT_LEGAL_ENTITY_ID	Character(150)	VARCHAR2(150) NOT NULL	LEGAL_ENTITY_ID
10	FT_PRMRY_LEDGERID	Character(150)	VARCHAR2(150) NOT NULL	LEGAL_ENTITY_ID
11	DEFAULT_SETID	Character(5)	VARCHAR2(5) NOT NULL	Default SetID
12	FT_SET_ID_GUID	Character(36)	VARCHAR2(36) NOT NULL	Set ID GUID
13	FT_HR_ENABLED_FLG	Character(30)	VARCHAR2(30) NOT NULL	Enabled for HR
14	FT_FINANCIAL_BU_ID	Character(150)	VARCHAR2(150) NOT NULL	LEGAL_ENTITY_ID
15	FT_DFLT_CURRENCY	Character(30)	VARCHAR2(30) NOT NULL	Default Currency Code
16	FT_CLASSIFICATION	Character(50)	VARCHAR2(50) NOT NULL	Classification Code
17	FT_EFF_START_DATE	Date(10)	DATE	Effective Start Date
18	FT_EFF_END_DATE	Date(10)	DATE	Effective End Date
19	FT_ORG_INFO_CONTXT	Character(40)	VARCHAR2(40) NOT NULL	ORG_INFORMATION_CONTEXT
20	FT_ORG_ID1	Number(18,0)	DECIMAL(18) NOT NULL	LEGAL_ENTITY_ID
21	FT_CLASSIFICATION1	Character(50)	VARCHAR2(50) NOT NULL	Classification Code
22	FT_LANGUAGE	Character(4)	VARCHAR2(4) NOT NULL	Language
23	FT_PROC_MARKER	Character(36)	VARCHAR2(36) NOT NULL	Process marker field
24	FT_ERROR_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Error Flag N=No Y=Yes Default Value: N
25	FT_BYPASS_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Bypass Flag Default Value: N
26	FT_ALTERNATE_REC	Character(50)	VARCHAR2(50) NOT NULL	Source Record
27	FT_ALTERNATE_KEY	Character(254)	VARCHAR2(254) NOT NULL	Alternate Key