ASSET_LOC_E (SQL Table)	Index Back
Asset Location

ASSET_LOC_E

(SQL Table)

Asset Location

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 TEST_CASE Character(30) VARCHAR2(30) NOT NULL BTF Test Case

2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BU_AM_NONVW

3 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification

4 EFFDT Date(10) DATE Effective Date
Default Value: %date

5 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence

6 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
Prompt Table: LOCATION_TBL

7 DOCUMENT_ID Character(12) VARCHAR2(12) NOT NULL Document

8 AUTH_STATUS Character(1) VARCHAR2(1) NOT NULL Authorization Status
A=Authorized
N=Not Authorized
P=Authorization Pending

9 AUTHORIZATION_NAME Character(30) VARCHAR2(30) NOT NULL Authorization Name

10 AUTHORIZATION_DT Date(10) DATE Date Authorized

11 AREA_ID Character(10) VARCHAR2(10) NOT NULL Area ID
Prompt Table: AM_AREA_TBL

12 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.

13 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time

14 DTTM_REFRESHED DateTime(26) TIMESTAMP Specifies the date and time of the last refresh of the expected results data. This field is used in the Batch Test Framework process.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TEST_CASE	Character(30)	VARCHAR2(30) NOT NULL	BTF Test Case
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_AM_NONVW
3	ASSET_ID	Character(12)	VARCHAR2(12) NOT NULL	Asset Identification
4	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
5	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
6	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code Prompt Table: LOCATION_TBL
7	DOCUMENT_ID	Character(12)	VARCHAR2(12) NOT NULL	Document
8	AUTH_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Authorization Status A=Authorized N=Not Authorized P=Authorization Pending
9	AUTHORIZATION_NAME	Character(30)	VARCHAR2(30) NOT NULL	Authorization Name
10	AUTHORIZATION_DT	Date(10)	DATE	Date Authorized
11	AREA_ID	Character(10)	VARCHAR2(10) NOT NULL	Area ID Prompt Table: AM_AREA_TBL
12	SYNCID	Number(10,0)	DECIMAL(10) NOT NULL	The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
13	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time
14	DTTM_REFRESHED	DateTime(26)	TIMESTAMP	Specifies the date and time of the last refresh of the expected results data. This field is used in the Batch Test Framework process.