Request Segregation of Duties-Risk

DataSource Transactional Data: 0GAE_SOD_RISK

This is a transactional DataSource used to find the Segregation of Duties – Risk related details of the Current (Non- Archived) requests.

The UD source System needs to be configured first with the Release Type: GAC and Content Version: 000

Currently, the DataSource has no delta available.

Fields of Origin for the Extract Structure
Fields in the Extract Structure	Description of the Field in the Extract Structure	Table of Origin	Field in the Table of Origin
`REQNO`	REQNO	`VT_AE_RQ_SO_RSK`	`REQNO`
`USERID`	USERID	`VT_AE_RQ_SO_RSK`	`USERID`
`RISK_ID`	RISK_ID	`VT_AE_RQ_SO_RSK`	`RISK_ID`
`USER_FIRST_NAME`	USER_FIRST_NAME	`VT_AE_RQ_SO_RSK`	`USER_FIRST_NAME`
`USER_LAST_NAME`	USER_LAST_NAME	`VT_AE_RQ_SO_RSK`	`USER_LAST_NAME`
`RISK_LEVEL`	RISK_LEVEL	`VT_AE_RQ_SO_RSK`	`RISK_LEVEL`
`LAST_EXECUTED_ON`	LAST_EXECUTED_ON	`VT_AE_RQ_SO_RSK`	`LAST_EXECUTED_ON`
`LAST_EXECUTED_O`	LAST_EXECUTED_O	`VT_AE_RQ_SO_RSK`	`LAST_EXECUTED_O`
`RISK_ACTION`	RISK_ACTION	`VT_AE_RQ_SO_RSK`	`RISK_ACTION`
`MIT_CONTROL_ID`	MIT_CONTROL_ID	`VT_AE_RQ_SO_RSK`	`MIT_CONTROL_ID`
`MIT_VALID_FROM_D`	MIT_VALID_FROM_D	`VT_AE_RQ_SO_RSK`	`MIT_VALID_FROM_D`
`MIT_VALID_FROM_T`	MIT_VALID_FROM_T	`VT_AE_RQ_SO_RSK`	`MIT_VALID_FROM_T`
`MIT_VALID_TO_D`	MIT_VALID_TO_D	`VT_AE_RQ_SO_RSK`	`MIT_VALID_TO_D`
`MIT_VALID_TO_T`	MIT_VALID_TO_T	`VT_AE_RQ_SO_RSK`	`MIT_VALID_TO_T`
`MIT_MONITOR_ID`	MIT_MONITOR_ID	`VT_AE_RQ_SO_RSK`	`MIT_MONITOR_ID`
`MIT_FUNC_AREA`	MIT_FUNC_AREA	`VT_AE_RQ_SO_RSK`	`MIT_FUNC_AREA`
`MIT_MGR_APPROVER`	MIT_MGR_APPROVER	`VT_AE_RQ_SO_RSK`	`MIT_MGR_APPROVER`
`USER_ORGANIZATIO`	USER_ORGANIZATIO	`VT_AE_RQ_SO_RSK`	`USER_ORGANIZATIO`

The extractor logic is Direct Assignment.