PeopleSoft Data Conversion Requirements Gathering Checklist

In this doodle I will share my PeopleSoft Data Conversion requirements gathering checklist. Many times after my requirement gathering meetings I used to think I have missed  at least one important information that has to be captured. I have to get in touch with stake holders again to gather the missing information's  Considering this happening more frequently I started creating my checklist of questions that I need to discuss in my requirements meeting.

This checklist helps me to save time and complete requirements gathering more efficiently. This checklist will undergo changes based on my future experiences and also based on my readers valuable comments.

Based on your requirement and design you can pick the right questions that is more appropriate to complete your specifications document.

Checklist Items
1	Detail Description of the data conversion
2	Description of the source and Target systems involved
3	Technology to develop this interface (if there is an preference) - AE/SQR/ ETL/ExcelToCI/CI
4	Sample conversion data file
5	PeopleSoft Modules that are impacted
Data Mapping
6	Mapping between source system table or File to PeopleSoft Tables
7	Source System data attributes ( Column type, length, format etc) for each column
8	Default values for the required columns (if any) when no value is provided
9	Required Columns list (Rules should state what has to be done if any required column is missing)
10	Mapping rules for the columns that needs transformation
11	List of PeopleSoft Tables involved in conversion
12	Information on PeopleSoft Component and Pages involved (if needed)
13	Error/Exception handling strategy
Business Processing Logic
14	Whether data that will be provided for conversion will be raw or processed data? If raw require processing logic for converting this raw data
15	If data for conversion has to selected by program then require information on selection criteria from the source system.
16	Any Business specific execution logic's that has to be included in the conversion program
17	PreLoad business validations
18	PostLoad business validations
19	Transformation Logic's
Conversion Data
20	Whether history data is converted ? If so how old history data ?
21	Data mapping that has to be used for converting history data (if any)
22	Whether there is any Prerequisite conversion or PS data setup needed for this conversion? If yes whether those information's are available in the document ?
23	How conversion data will be sent to PeopleSoft ? (File, Database Link etc)
24	Any setup data that has to be configured for this conversion
25	Whether this conversion has dependency on online customization ? If so require information on the conversion approach based on this customization
26	Whether Conversion data will be received in single file or Multiple files ? If multiple file order in which files has to be loaded.
27	Order in which PeopleSoft Tables has to be loaded
28	Input file name format
29	Input file layout and file delimiter
30	Expected volume of data that has to be migrated
31	Expected time for the process to load the data