Migrating Data Using Application Data Sets

PeopleSoft Application Data Sets (ADS) are delivered for key setup data records to simplify the administration, testing, and transfer of setup data between databases. Once specific setup data is defined and tested in a testing environment, ADS helps move the data (along with their related data counterparts) easily between databases. Since the relationships between the setup data records are maintained and pre-delivered into the ADS, there are less issues to consider, especially when compared with running traditional Data Mover scripts. ADS records are delivered in PeopleSoft Expenses for:

Expense Types, Expense Type Groups, Expense Type Categories
Expense Locations, Location Amounts
Approval Workflow configuration (Approver Stages, Refinement Templates, Risk Templates)
Roles and Privilege Templates (employee & approver)
Per Diem (including Range Categories, Ranges, Per Diem Amounts, Formulas)

The data set project use these data sets in PeopleSoft Expenses to copy data from one system to another system.

Delivered ADS to Support PeopleSoft Expenses	Record	Description
EX_APPRVR_ASSIGN	EX_APPRVR	EXPENSES APPROVER ASSIGNMENTS
EX_APPRVR_LIST	EX_TRANS_RTG EX_TRANS_RTGLST	EXPENSES APPROVER ROUTING LIST
EX_APPRVR_PROF	EX_PROF_APPRVR EX_PROF_ATTR	EXPENSE APPROVER PROFILE
EX_APPRVR_TYPE	EX_APPRVR_TYPE	EXPENSE APPROVER TYPE
EX_EE_PRIV_TMPL	EX_EE_PRIV_TMPL EX_EE_PRIV_CF	EXPENSE EE PRIVILEGE TEMPLATE
EX_LOC	EX_LOCATION_TBL	EXPENSE LOCATION
EX_LOC_AMT	EX_LOC_AMOUNT EX_LOC_AMT_DTL	EXPENSE LOCATION AMOUNT
EX_LOC_GRP	EX_LOC_GRP_TBL	EXPENSE LOCATION GROUP
EX_LOC_AMT_TYPE_GRP	EX_LOC_AMT_GRP EX_LOCAMT_G_DTL	EXPENSE LOCATION AMOUNT TYPE GROUP
EX_MERCHANT	EX_MERCHANT_TBL	EXPENSES PREFERRED MERCHANT
EX_PD_CALC	EX_PD_CALC_TBL EX_PD_CALC_DTL	EXPENSE PER DIEM CALCULATION
EX_PD_CATEGORY	EX_CATEGORY_TBL	EXPENSE PER DIEM CATEGORY
EX_PER_DIEM_AMT	EX_PER_DIEM_TBL EX_PER_DIEM_DTL	EXPENSE PER DIEM AMOUNT
EX_PER_DIEM_RANGE	EX_RANGE_TBL EX_RANGE_DTL	EXPENSE PER DIEM RANGE
EX_PRIV_TMPL	EX_PRIV_TMPL	EXPENSE PRIVILEGE TEMPLATE
EX_REFINE_TMPL	EX_REFINE_TMPL EX_REFINE_DEPT EX_REFINE_EE EX_REFINE_BU EX_REFINE_TRC EX_REFINE_TYPES	EXPENSE REFINEMENT TEMPLATE
EX_RISK_TMPL	EX_RISK_TMPL EX_RISK_BU EX_RISK_BUSPURP EX_RISK_DEPT EX_RISK_EE EX_RISK_AUTHAMT EX_RISK_TOTLMT EX_RISK_TRC EX_RISK_TYPLMT	EXPENSE RISK TEMPLATE
EX_ROLE	EX_ROLE_TBL EX_ROLE_PRIV	EXPENSE ROLE
EX_ROLE_EXCEPTION	EX_ROLE_TBL EX_ROLE_EXCP_ET EX_ROLE_EXC_ETG	EXPENSE ROLE EXCEPTION
EX_ROLE_EXP_TYPE	EX_ROLE_TBL EX_ROLE_EXP_TYP	EXPENSE ROLE EXPENSE TYPE
EX_ROLE_VAT	EX_ROLE_EXCP_VT	EXPENSE ROLE VAT
EX_TRANS_DEFN	EX_TRANS_DEFN EX_TRANS_PROP	EXPENSE TRANSACTION DEFINITION
EX_TYPE	EX_TYPES_TBL EX_TYPES_CF_TBL EX_TYPE_MERCHNT EX_TYPE_PERDIEM	EXPENSE TYPES
EX_TYPE_CAT	EX_TYPE_CAT_TBL EX_TYPE_CAT_DTL	EXPENSE TYPE CATEGORY
EX_TYPE_GRP	EX_TYPE_GRP_TBL EX_TYPGP_CF_TBL	EXPENSE TYPE GROUP
EX_TYPE_IMG	EX_EXP_TYPE_IMG	EXPENSE TYPE IMAGE