31 lines
4.1 KiB
SQL
31 lines
4.1 KiB
SQL
|
|
use EnVisage
|
|
delete from supt_tbl_RecParser where ProcessID='Update PeopleResources2'
|
|
|
|
insert into supt_tbl_RecParser (Id,ProcessID,ToType,ToName,ToField,StartPos,[Length],[index],isDelimited,Delimitor,AdditionalFormat,Overlay,DBFieldFormat,TableOrder,ForeignKey)
|
|
values(NEWID(),'Update PeopleResources','API','PeopleResourceAPIModel','JobCode',0,500,8,'y','|',null,'False',null,null,null)
|
|
insert into supt_tbl_RecParser (Id,ProcessID,ToType,ToName,ToField,StartPos,[Length],[index],isDelimited,Delimitor,AdditionalFormat,Overlay,DBFieldFormat,TableOrder,ForeignKey)
|
|
values(NEWID(),'Update PeopleResources','API','PeopleResourceAPIModel','Title',0,500,7,'y','|','Required','False',NULL,NULL,NULL)
|
|
insert into supt_tbl_RecParser (Id,ProcessID,ToType,ToName,ToField,StartPos,[Length],[index],isDelimited,Delimitor,AdditionalFormat,Overlay,DBFieldFormat,TableOrder,ForeignKey)
|
|
values(NEWID(),'Update PeopleResources','API','PeopleResourceAPIModel','CreditNumber',0,500,9,'y','|','Required','False',NULL,NULL,NULL)
|
|
insert into supt_tbl_RecParser (Id,ProcessID,ToType,ToName,ToField,StartPos,[Length],[index],isDelimited,Delimitor,AdditionalFormat,Overlay,DBFieldFormat,TableOrder,ForeignKey)
|
|
values(NEWID(),'Update PeopleResources','API','PeopleResourceAPIModel','ProcessReturnMessage',0,500,0,'N','','Empty','False',NULL,NULL,NULL)
|
|
insert into supt_tbl_RecParser (Id,ProcessID,ToType,ToName,ToField,StartPos,[Length],[index],isDelimited,Delimitor,AdditionalFormat,Overlay,DBFieldFormat,TableOrder,ForeignKey)
|
|
values(NEWID(),'Update PeopleResources','API','PeopleResourceAPIModel','EmployeeID',0,500,0,'y','|','Required','False',NULL,NULL,NULL)
|
|
insert into supt_tbl_RecParser (Id,ProcessID,ToType,ToName,ToField,StartPos,[Length],[index],isDelimited,Delimitor,AdditionalFormat,Overlay,DBFieldFormat,TableOrder,ForeignKey)
|
|
values(NEWID(),'Update PeopleResources','API','PeopleResourceAPIModel','LastName',0,500,1,'y','|','Required','False',NULL,NULL,NULL)
|
|
insert into supt_tbl_RecParser (Id,ProcessID,ToType,ToName,ToField,StartPos,[Length],[index],isDelimited,Delimitor,AdditionalFormat,Overlay,DBFieldFormat,TableOrder,ForeignKey)
|
|
values(NEWID(),'Update PeopleResources','API','PeopleResourceAPIModel','EmailAddress',0,500,6,'y','|','Required','False',NULL,NULL,NULL)
|
|
insert into supt_tbl_RecParser (Id,ProcessID,ToType,ToName,ToField,StartPos,[Length],[index],isDelimited,Delimitor,AdditionalFormat,Overlay,DBFieldFormat,TableOrder,ForeignKey)
|
|
values(NEWID(),'Update PeopleResources','API','PeopleResourceAPIModel','StartDate',0,500,19,'y','|','Required','False',NULL,NULL,NULL)
|
|
insert into supt_tbl_RecParser (Id,ProcessID,ToType,ToName,ToField,StartPos,[Length],[index],isDelimited,Delimitor,AdditionalFormat,Overlay,DBFieldFormat,TableOrder,ForeignKey)
|
|
values(NEWID(),'Update PeopleResources','API','PeopleResourceAPIModel','LineNumber',0,500,0,'N','','LineNumber','False',NULL,NULL,NULL)
|
|
insert into supt_tbl_RecParser (Id,ProcessID,ToType,ToName,ToField,StartPos,[Length],[index],isDelimited,Delimitor,AdditionalFormat,Overlay,DBFieldFormat,TableOrder,ForeignKey)
|
|
values(NEWID(),'Update PeopleResources','API','PeopleResourceAPIModel','EndDate',0,500,16,'y','|','NOTNULL','False',NULL,NULL,NULL)
|
|
insert into supt_tbl_RecParser (Id,ProcessID,ToType,ToName,ToField,StartPos,[Length],[index],isDelimited,Delimitor,AdditionalFormat,Overlay,DBFieldFormat,TableOrder,ForeignKey)
|
|
values(NEWID(),'Update PeopleResources','API','PeopleResourceAPIModel','FirstName',0,500,2,'y','|','Required','False',NULL,NULL,NULL)
|
|
insert into supt_tbl_RecParser (Id,ProcessID,ToType,ToName,ToField,StartPos,[Length],[index],isDelimited,Delimitor,AdditionalFormat,Overlay,DBFieldFormat,TableOrder,ForeignKey)
|
|
values(NEWID(),'Update PeopleResources','API','PeopleResourceAPIModel','ReassignOnDeactivation',0,500,0,'N','','True','False',NULL,NULL,NULL)
|
|
insert into supt_tbl_RecParser (Id,ProcessID,ToType,ToName,ToField,StartPos,[Length],[index],isDelimited,Delimitor,AdditionalFormat,Overlay,DBFieldFormat,TableOrder,ForeignKey)
|
|
values(NEWID(),'Update PeopleResources','API','PeopleResourceAPIModel','IsActiveEmployee',0,500,16,'Y','|','NULL=True','False',NULL,NULL,NULL)
|