RE_SAR_DETAIL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SAR_ID	Character(15)	VARCHAR2(15) NOT NULL	SAR ID
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	SITE_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Site Type
4	SAR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	SAR Status 1=Pending 2=Active 3=Evaluating Finalists 4=Sites Selected 5=Finalised 6=Cancel Default Value: 1
5	SAR_NAME	Character(60)	VARCHAR2(60) NOT NULL	Site Acquisition Request Name
6	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location Prompt Table: RE_VNDR_LOC
7	REGION_CD	Character(10)	VARCHAR2(10) NOT NULL	Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to. Prompt Table: RE_REGION_NAME
8	DESCRLONG	Long Character	CLOB	Long Description
9	SAR_START_DT	Date(10)	DATE	Commencement
10	ESTIMATED_COMP_DT	Date(10)	DATE	Estimated Completion Date
11	ACTUAL_COMP_DT	Date(10)	DATE	Actual Completion Date
12	RE_SPECIALIST	Number(10,0)	DECIMAL(10) NOT NULL	Real Estate Specialist Prompt Table: RE_PARTY_LA
13	PRTFL_MGR	Number(10,0)	DECIMAL(10) NOT NULL	Portfolio Manager Prompt Table: RE_PARTY_PM
14	APPROVER	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: RE_PARTY_LA
15	FMS_DTTM_STAMP	DateTime(26)	TIMESTAMP	Specifies the date and time of the original entry.
16	FMS_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the original entry.
17	FMS_LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry.
18	FMS_LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry.