API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Nov 20th, 2017
124
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 106.50 KB | None | 0 0
raw download clone embed print report
  1. {
  2. "data":{
  3. "name":"dsagtyg (AT) 2017-11-20 15:01:23",
  4. "timestamp":1511190083073,
  5. "columns":[
  6. {
  7. "mappedColumnName":"YOUR_SUKA_EEID;REV_SUKA_RESP;BIRTH_SUKA_YEAR;HIRE_SUKA_YEAR;GENDER_SUKA_CODE;REG_SUKA_CODE_SUKA_ORIG;POS_SUKA_CODE;YOUR_SUKA_TITLE;RPTSTO;YOUR_SUKA_CODE;YOUR_SUKA_LEVEL;YOUR_SUKA_GRADE;YOUR_SUKA_OTHER;THERA_SUKA_FLAG;POS_SUKA_CLASS;REGION_SUKA_RESP;CURR_SUKA_CODE;MONTH_SUKA_BASE;NUM_SUKA_MONTH;ANNUAL_SUKA_BASE;ROLE_SUKA_CH;HOL_SUKA_ENT;TRANS_SUKA_ALLOW;MEAL_SUKA_ALLOW;SHIFT_SUKA_ALLOW;OTH_SUKA_ALLOW;BON_SUKA_ELIG;BONUS_SUKA_TPER;MAXBON_SUKA_TPER;BONUS_SUKA_ACT;COMM_SUKA_ELIG;COMM_SUKA_TPER;COMM_SUKA_ACT;OTH_SUKA_BONUS;LTI_SUKA_ELIG;LTINAME_SUKA_1;LTISHARECASH_SUKA_1;LTINAME_SUKA_2;LTISHARECASH_SUKA_2;LTINAME_SUKA_3;LTISHARECASH_SUKA_3;CAR_SUKA_BEN_SUKA_TYPE;CAR_SUKA_ALLOW;CAR_SUKA_LISTPRICE;CAR_SUKA_MLEASE;CAR_SUKA_REPL;CAR_SUKA_FUEL;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;",
  8. "skip":false
  9. },
  10. {
  11. "mappedColumnName":"YOUR_EEID",
  12. "code":"YOUR_EEID",
  13. "skip":false
  14. }
  15. ],
  16. "section":{
  17. "_id":"59ef34f9626de5172470f541",
  18. "code":"incumbent_data",
  19. "name":"Incumbent Data",
  20. "displayLabel":"Incumbent Data",
  21. "displayDescription":"Incumbent Data",
  22. "cardinality":"many",
  23. "formMode":"none",
  24. "isUploadable":true,
  25. "updateDate":"2017-10-24T12:42:09.633Z",
  26. "type":"section",
  27. "__v":0,
  28. "children":[
  29. {
  30. "_id":"59ef34f9626de5172470f53e",
  31. "code":"incumbent_fields",
  32. "name":"Incumbent Fields",
  33. "displayLabel":"Incumbent Fields",
  34. "updateDate":"2017-10-24T12:42:09.589Z",
  35. "referenceColumns":[
  36. "YOUR_CODE",
  37. "YOUR_LEVEL"
  38. ],
  39. "type":"questionGroup",
  40. "tags":[
  41.  
  42. ],
  43. "__v":0,
  44. "children":[
  45. {
  46. "_id":"59ef34f9626de5172470f500",
  47. "code":"YOUR_EEID",
  48. "name":"Employee Identifier",
  49. "displayLabel":"Employee Identifier",
  50. "questionType":"integer",
  51. "dataType":"int",
  52. "hidden":false,
  53. "updateDate":"2017-10-24T12:42:09.170Z",
  54. "type":"question",
  55. "tags":[
  56.  
  57. ],
  58. "validators":[
  59. {
  60. "errorType":"error",
  61. "validationType":"expression",
  62. "expression":"isnotblank(this.YOUR_EEID)",
  63. "errorGroup":"base_salary",
  64. "message":"YOUR_EEID value can not be null or empty",
  65. "_id":"59ef3521626de51724712e15",
  66. "category":"input_data",
  67. "dependentColumns":[
  68.  
  69. ]
  70. }
  71. ],
  72. "industries":[
  73.  
  74. ],
  75. "countries":[
  76.  
  77. ],
  78. "__v":0
  79. },
  80. {
  81. "_id":"59ef34f9626de5172470f501",
  82. "code":"REV_RESP",
  83. "name":"Revenue for business in which role sits (in millions EUR)",
  84. "displayLabel":"Revenue for business in which role sits (in millions EUR)",
  85. "questionType":"integer",
  86. "dataType":"int",
  87. "hidden":false,
  88. "updateDate":"2017-10-24T12:42:09.189Z",
  89. "type":"question",
  90. "tags":[
  91.  
  92. ],
  93. "validators":[
  94.  
  95. ],
  96. "industries":[
  97.  
  98. ],
  99. "countries":[
  100.  
  101. ],
  102. "__v":0
  103. },
  104. {
  105. "_id":"59ef34f9626de5172470f502",
  106. "code":"BIRTH_YEAR",
  107. "name":"Year of Birth",
  108. "displayLabel":"Year of Birth",
  109. "questionType":"integer",
  110. "dataType":"int",
  111. "hidden":false,
  112. "updateDate":"2017-10-24T12:42:09.199Z",
  113. "type":"question",
  114. "tags":[
  115.  
  116. ],
  117. "validators":[
  118. {
  119. "errorType":"error",
  120. "validationType":"expression",
  121. "expression":"decode(this.BIRTH_YEAR >= 1940,decode(this.BIRTH_YEAR <= 2000,'true','false'),'false')",
  122. "errorGroup":"job_info",
  123. "message":"BIRTH_YEAR value is invalid",
  124. "_id":"59ef3521626de51724712e16",
  125. "category":"input_data",
  126. "dependentColumns":[
  127.  
  128. ]
  129. }
  130. ],
  131. "industries":[
  132.  
  133. ],
  134. "countries":[
  135.  
  136. ],
  137. "__v":0
  138. },
  139. {
  140. "_id":"59ef34f9626de5172470f503",
  141. "code":"HIRE_YEAR",
  142. "name":"Year of Hire",
  143. "displayLabel":"Year of Hire",
  144. "questionType":"integer",
  145. "dataType":"int",
  146. "hidden":false,
  147. "updateDate":"2017-10-24T12:42:09.206Z",
  148. "type":"question",
  149. "tags":[
  150.  
  151. ],
  152. "validators":[
  153. {
  154. "errorType":"error",
  155. "validationType":"expression",
  156. "expression":"decode (this.HIRE_YEAR > 1950,decode(this.HIRE_YEAR < 2017,'true','false'),'false')",
  157. "errorGroup":"job_info",
  158. "message":"HIRE_YEAR value is invalid",
  159. "_id":"59ef3521626de51724712e17",
  160. "category":"input_data",
  161. "dependentColumns":[
  162.  
  163. ]
  164. }
  165. ],
  166. "industries":[
  167.  
  168. ],
  169. "countries":[
  170.  
  171. ],
  172. "__v":0
  173. },
  174. {
  175. "_id":"59ef34f9626de5172470f504",
  176. "code":"GENDER_CODE",
  177. "name":"Gender",
  178. "displayLabel":"Gender",
  179. "questionType":"text",
  180. "dataType":"string",
  181. "hidden":false,
  182. "updateDate":"2017-10-24T12:42:09.212Z",
  183. "type":"question",
  184. "tags":[
  185.  
  186. ],
  187. "validators":[
  188. {
  189. "errorType":"error",
  190. "validationType":"expression",
  191. "expression":"decode(findin_set(this.GENDER_CODE,'M,F'), 'false', 'true')",
  192. "errorGroup":"job_info",
  193. "message":"GENDER_CODE value is invalid",
  194. "_id":"59ef3521626de51724712e18",
  195. "category":"input_data",
  196. "dependentColumns":[
  197.  
  198. ]
  199. }
  200. ],
  201. "industries":[
  202.  
  203. ],
  204. "countries":[
  205.  
  206. ],
  207. "__v":0
  208. },
  209. {
  210. "_id":"59ef34f9626de5172470f505",
  211. "code":"REG_CODE_ORIG",
  212. "name":"Region in which role is located",
  213. "displayLabel":"Region in which role is located",
  214. "questionType":"text",
  215. "dataType":"string",
  216. "hidden":false,
  217. "updateDate":"2017-10-24T12:42:09.216Z",
  218. "type":"question",
  219. "tags":[
  220.  
  221. ],
  222. "validators":[
  223. {
  224. "errorType":"error",
  225. "validationType":"expression",
  226. "expression":"decode(findin_set(this.REG_CODE_ORIG,'West London,London,East London'), 'false', 'true')",
  227. "errorGroup":"job_info",
  228. "message":"REG_CODE_ORIG value is invalid",
  229. "_id":"59ef3521626de51724712e19",
  230. "category":"input_data",
  231. "dependentColumns":[
  232.  
  233. ]
  234. }
  235. ],
  236. "industries":[
  237.  
  238. ],
  239. "countries":[
  240.  
  241. ],
  242. "__v":0
  243. },
  244. {
  245. "_id":"59ef34f9626de5172470f506",
  246. "code":"YOUR_TITLE",
  247. "name":"Organisation Job Title",
  248. "displayLabel":"Organisation Job Title",
  249. "questionType":"text",
  250. "dataType":"string",
  251. "hidden":false,
  252. "updateDate":"2017-10-24T12:42:09.220Z",
  253. "type":"question",
  254. "tags":[
  255.  
  256. ],
  257. "validators":[
  258. {
  259. "errorType":"error",
  260. "validationType":"expression",
  261. "expression":"isnotblank(this.YOUR_TITLE)",
  262. "errorGroup":"base_salary",
  263. "message":"YOUR_TITLE value can not be null or empty",
  264. "_id":"59ef3521626de51724712e1a",
  265. "category":"input_data",
  266. "dependentColumns":[
  267.  
  268. ]
  269. }
  270. ],
  271. "industries":[
  272.  
  273. ],
  274. "countries":[
  275.  
  276. ],
  277. "__v":0
  278. },
  279. {
  280. "_id":"59ef34f9626de5172470f507",
  281. "code":"POS_CODE",
  282. "name":"Mercer Universal Position Code (MUPCS®)",
  283. "displayLabel":"Mercer Universal Position Code (MUPCS®)",
  284. "questionType":"text",
  285. "dataType":"string",
  286. "hidden":false,
  287. "updateDate":"2017-10-24T12:42:09.223Z",
  288. "type":"question",
  289. "tags":[
  290.  
  291. ],
  292. "validators":[
  293. {
  294. "errorType":"error",
  295. "validationType":"expression",
  296. "expression":"isnotblank(this.POS_CODE)",
  297. "errorGroup":"job_info",
  298. "message":"POS_CODE value can not be null or empty",
  299. "_id":"59ef3521626de51724712e1b",
  300. "category":"input_data",
  301. "dependentColumns":[
  302.  
  303. ]
  304. }
  305. ],
  306. "industries":[
  307.  
  308. ],
  309. "countries":[
  310.  
  311. ],
  312. "__v":0
  313. },
  314. {
  315. "_id":"59ef34f9626de5172470f508",
  316. "code":"RPTSTO",
  317. "displayLabel":"Organisation's Reports to Position Title",
  318. "name":"Organisation's Reports to Position Title",
  319. "questionType":"text",
  320. "dataType":"string",
  321. "hidden":false,
  322. "updateDate":"2017-10-24T12:42:09.228Z",
  323. "type":"question",
  324. "tags":[
  325.  
  326. ],
  327. "validators":[
  328.  
  329. ],
  330. "industries":[
  331.  
  332. ],
  333. "countries":[
  334.  
  335. ],
  336. "__v":0
  337. },
  338. {
  339. "_id":"59ef34f9626de5172470f509",
  340. "code":"YOUR_CODE",
  341. "name":"Organisation Job Code (Optional)",
  342. "displayLabel":"Organisation Job Code (Optional)",
  343. "questionType":"text",
  344. "dataType":"string",
  345. "hidden":false,
  346. "updateDate":"2017-10-24T12:42:09.231Z",
  347. "type":"question",
  348. "tags":[
  349.  
  350. ],
  351. "validators":[
  352.  
  353. ],
  354. "industries":[
  355.  
  356. ],
  357. "countries":[
  358.  
  359. ],
  360. "__v":0
  361. },
  362. {
  363. "_id":"59ef34f9626de5172470f50a",
  364. "code":"YOUR_LEVEL",
  365. "name":"Organisation Job Level (Optional)",
  366. "displayLabel":"Organisation Job Level (Optional)",
  367. "questionType":"text",
  368. "dataType":"string",
  369. "hidden":false,
  370. "updateDate":"2017-10-24T12:42:09.233Z",
  371. "type":"question",
  372. "tags":[
  373.  
  374. ],
  375. "validators":[
  376.  
  377. ],
  378. "industries":[
  379.  
  380. ],
  381. "countries":[
  382.  
  383. ],
  384. "__v":0
  385. },
  386. {
  387. "_id":"59ef34f9626de5172470f50b",
  388. "code":"YOUR_GRADE",
  389. "name":"Organisation Job Grade (Optional)",
  390. "displayLabel":"Organisation Job Grade (Optional)",
  391. "questionType":"integer",
  392. "dataType":"int",
  393. "hidden":false,
  394. "updateDate":"2017-10-24T12:42:09.236Z",
  395. "type":"question",
  396. "tags":[
  397.  
  398. ],
  399. "validators":[
  400.  
  401. ],
  402. "industries":[
  403.  
  404. ],
  405. "countries":[
  406.  
  407. ],
  408. "__v":0
  409. },
  410. {
  411. "_id":"59ef34f9626de5172470f50c",
  412. "code":"YOUR_OTHER",
  413. "name":"Organisation Job ID - Other",
  414. "displayLabel":"Organisation Job ID - Other",
  415. "questionType":"integer",
  416. "dataType":"int",
  417. "hidden":false,
  418. "updateDate":"2017-10-24T12:42:09.240Z",
  419. "type":"question",
  420. "tags":[
  421.  
  422. ],
  423. "validators":[
  424.  
  425. ],
  426. "industries":[
  427.  
  428. ],
  429. "countries":[
  430.  
  431. ],
  432. "__v":0
  433. },
  434. {
  435. "_id":"59ef34f9626de5172470f50d",
  436. "code":"THERA_FLAG",
  437. "name":"Therapeutic Area Flag",
  438. "displayLabel":"Therapeutic Area Flag",
  439. "questionType":"integer",
  440. "dataType":"int",
  441. "hidden":false,
  442. "updateDate":"2017-10-24T12:42:09.245Z",
  443. "type":"question",
  444. "tags":[
  445.  
  446. ],
  447. "validators":[
  448.  
  449. ],
  450. "industries":[
  451.  
  452. ],
  453. "countries":[
  454.  
  455. ],
  456. "__v":0
  457. },
  458. {
  459. "_id":"59ef34f9626de5172470f50e",
  460. "code":"POS_CLASS",
  461. "name":"IPE Position Class (current year)",
  462. "displayLabel":"IPE Position Class (current year)",
  463. "questionType":"integer",
  464. "dataType":"int",
  465. "hidden":false,
  466. "updateDate":"2017-10-24T12:42:09.247Z",
  467. "type":"question",
  468. "tags":[
  469.  
  470. ],
  471. "validators":[
  472. {
  473. "errorType":"error",
  474. "validationType":"expression",
  475. "expression":"decode(this.POS_CLASS < 40,'false',decode(this.POS_CLASS > 84,'false','true'))",
  476. "errorGroup":"job_info",
  477. "message":"POS_CLASS value is invalid",
  478. "_id":"59ef3521626de51724712e1c",
  479. "category":"input_data",
  480. "dependentColumns":[
  481.  
  482. ]
  483. }
  484. ],
  485. "industries":[
  486.  
  487. ],
  488. "countries":[
  489.  
  490. ],
  491. "__v":0
  492. },
  493. {
  494. "_id":"59ef34f9626de5172470f50f",
  495. "code":"POS_CLASS_ADJUST",
  496. "name":"IPE Position Class when adjusted",
  497. "displayLabel":"IPE Position Class when adjusted",
  498. "questionType":"integer",
  499. "dataType":"int",
  500. "hidden":false,
  501. "updateDate":"2017-10-24T12:42:09.262Z",
  502. "type":"question",
  503. "tags":[
  504.  
  505. ],
  506. "validators":[
  507. {
  508. "errorType":"error",
  509. "validationType":"expression",
  510. "expression":"decode(this.POS_CLASS_ADJUST < 40,'false',decode(this.POS_CLASS_ADJUST > 84,'false','true'))",
  511. "errorGroup":"job_info",
  512. "message":"POS_CLASS_ADJUST value is invalid",
  513. "_id":"59ef3521626de51724712e1d",
  514. "category":"input_data",
  515. "dependentColumns":[
  516.  
  517. ]
  518. }
  519. ],
  520. "industries":[
  521.  
  522. ],
  523. "countries":[
  524.  
  525. ],
  526. "__v":0
  527. },
  528. {
  529. "_id":"59ef34f9626de5172470f510",
  530. "code":"REGION_RESP",
  531. "name":"Geographic Scope of Role",
  532. "displayLabel":"Geographic Scope of Role",
  533. "questionType":"dropdown",
  534. "dataType":"string",
  535. "options":{
  536. "items":[
  537. {
  538. "value":"70_in_country",
  539. "displayName":"70 - In Country"
  540. },
  541. {
  542. "value":"10_global",
  543. "displayName":"10 - Global"
  544. },
  545. {
  546. "value":"20_multi_regional",
  547. "displayName":"20 - Multi Regional (2-5 regions)"
  548. },
  549. {
  550. "value":"30_regional",
  551. "displayName":"30 - Regional (e.g. Europe)"
  552. }
  553. ],
  554. "questionsAnswers":[
  555.  
  556. ]
  557. },
  558. "hidden":false,
  559. "updateDate":"2017-10-24T12:42:09.267Z",
  560. "type":"question",
  561. "tags":[
  562.  
  563. ],
  564. "validators":[
  565. {
  566. "errorType":"error",
  567. "validationType":"expression",
  568. "expression":"decode(findin_set(this.REGION_RESP,'70 - In Country,10 - Global,20 - Multi Regional (2-5 regions),30 - Regional (e.g. Europe)'), 'false', 'true')",
  569. "errorGroup":"job_info",
  570. "message":"REGION_RESP value is invalid",
  571. "_id":"59ef3521626de51724712e1e",
  572. "category":"input_data",
  573. "dependentColumns":[
  574.  
  575. ]
  576. }
  577. ],
  578. "industries":[
  579.  
  580. ],
  581. "countries":[
  582.  
  583. ],
  584. "__v":0
  585. },
  586. {
  587. "_id":"59ef34f9626de5172470f511",
  588. "code":"CURR_CODE",
  589. "name":"Currency Code",
  590. "displayLabel":"Currency Code",
  591. "questionType":"text",
  592. "dataType":"string",
  593. "hidden":false,
  594. "updateDate":"2017-10-24T12:42:09.273Z",
  595. "type":"question",
  596. "tags":[
  597.  
  598. ],
  599. "validators":[
  600.  
  601. ],
  602. "industries":[
  603.  
  604. ],
  605. "countries":[
  606.  
  607. ],
  608. "__v":0
  609. },
  610. {
  611. "_id":"59ef34f9626de5172470f512",
  612. "code":"MONTH_BASE",
  613. "name":"Monthly Base Salary (Equivalent to 100% work time)",
  614. "displayLabel":"Monthly Base Salary (Equivalent to 100% work time)",
  615. "questionType":"integer",
  616. "dataType":"int",
  617. "hidden":false,
  618. "updateDate":"2017-10-24T12:42:09.276Z",
  619. "type":"question",
  620. "tags":[
  621.  
  622. ],
  623. "validators":[
  624. {
  625. "errorType":"error",
  626. "validationType":"expression",
  627. "expression":"AGGREGATERANGECHECK(XAVG('MONTH_BASE', 'MONTH_BASE >= 10' , 'POS_CODE'), LOOKUPMAP(exadel_pos_code, '', 'POS_CODE','AVG_MONTH_BASE'), '>=')",
  628. "errorGroup":"base_salary",
  629. "message":"Average month salary is wrong",
  630. "parameter":"AGGREGATE_VALIDATION=Average month salary;",
  631. "_id":"59ef3521626de51724712e21",
  632. "category":"job_aggregate",
  633. "dependentColumns":[
  634.  
  635. ]
  636. },
  637. {
  638. "errorType":"error",
  639. "validationType":"expression",
  640. "expression":"AGGREGATERANGECHECK(XAVG('MONTH_BASE', 'MONTH_BASE >= 10' , 'POS_CLASS'), LOOKUPMAP(exadel_pos_class, '', 'POS_CLASS','AVG_MONTH_BASE'), '>=')",
  641. "errorGroup":"base_salary",
  642. "message":"Average month salary is wrong",
  643. "parameter":"AGGREGATE_VALIDATION=Average month salary;",
  644. "_id":"59ef3521626de51724712e20",
  645. "category":"pc_aggregate",
  646. "dependentColumns":[
  647.  
  648. ]
  649. },
  650. {
  651. "errorType":"error",
  652. "validationType":"expression",
  653. "expression":"INVERSIONCHECK(XAVG('MONTH_BASE', 'MONTH_BASE > 0','POS_CLASS'))",
  654. "errorGroup":"base_salary",
  655. "message":"Average month salary wrong by position class",
  656. "parameter":"AGGREGATE_VALIDATION=Average month salary;",
  657. "_id":"59ef3521626de51724712e1f",
  658. "category":"pc_inversion",
  659. "dependentColumns":[
  660.  
  661. ]
  662. }
  663. ],
  664. "industries":[
  665.  
  666. ],
  667. "countries":[
  668.  
  669. ],
  670. "__v":0
  671. },
  672. {
  673. "_id":"59ef34f9626de5172470f513",
  674. "code":"NUM_MONTH",
  675. "name":"Number of Months Paid",
  676. "displayLabel":"Number of Months Paid",
  677. "questionType":"integer",
  678. "dataType":"int",
  679. "hidden":false,
  680. "updateDate":"2017-10-24T12:42:09.280Z",
  681. "type":"question",
  682. "tags":[
  683.  
  684. ],
  685. "validators":[
  686. {
  687. "errorType":"autocorrect",
  688. "validationType":"expression",
  689. "expression":"decode(this.NUM_MONTH < 1, '1', decode(this.NUM_MONTH > 12, '12', this.NUM_MONTH))",
  690. "errorGroup":"base_salary",
  691. "message":"NUM_MONTH value can not be null or empty",
  692. "_id":"59ef3521626de51724712e22",
  693. "category":"input_data",
  694. "dependentColumns":[
  695.  
  696. ]
  697. }
  698. ],
  699. "industries":[
  700.  
  701. ],
  702. "countries":[
  703.  
  704. ],
  705. "__v":0
  706. },
  707. {
  708. "_id":"59ef34f9626de5172470f514",
  709. "code":"ANNUAL_BASE",
  710. "name":"Annual Base Salary (Equivalent to 100% work time)",
  711. "displayLabel":"Annual Base Salary (Equivalent to 100% work time)",
  712. "questionType":"integer",
  713. "dataType":"int",
  714. "hidden":false,
  715. "updateDate":"2017-10-24T12:42:09.284Z",
  716. "type":"question",
  717. "tags":[
  718.  
  719. ],
  720. "validators":[
  721. {
  722. "errorType":"error",
  723. "validationType":"expression",
  724. "expression":"decode(this.ANNUAL_BASE > 1000000,false,true)",
  725. "errorGroup":"base_salary",
  726. "message":"ANNUAL_BASE value can not be null or empty",
  727. "_id":"59ef3521626de51724712e26",
  728. "category":"input_data",
  729. "dependentColumns":[
  730.  
  731. ]
  732. },
  733. {
  734. "errorType":"error",
  735. "validationType":"expression",
  736. "expression":"AGGREGATERANGECHECK(XAVG('ANNUAL_BASE', 'ANNUAL_BASE >= 10' , 'POS_CODE'), LOOKUPMAP(exadel_pos_code, '', 'POS_CODE','AVG_ANNUAL_BASE'), '>=')",
  737. "errorGroup":"base_salary",
  738. "message":"Average annual salary is wrong",
  739. "parameter":"AGGREGATE_VALIDATION=Average annual salary;",
  740. "_id":"59ef3521626de51724712e25",
  741. "category":"job_aggregate",
  742. "dependentColumns":[
  743.  
  744. ]
  745. },
  746. {
  747. "errorType":"error",
  748. "validationType":"expression",
  749. "expression":"AGGREGATERANGECHECK(XAVG('ANNUAL_BASE', 'ANNUAL_BASE >= 10' , 'POS_CLASS'), LOOKUPMAP(exadel_pos_class, '', 'POS_CLASS','AVG_ANNUAL_BASE'), '>=')",
  750. "errorGroup":"base_salary",
  751. "message":"Average annual salary is wrong",
  752. "parameter":"AGGREGATE_VALIDATION=Average annual salary;",
  753. "_id":"59ef3521626de51724712e24",
  754. "category":"pc_aggregate",
  755. "dependentColumns":[
  756.  
  757. ]
  758. },
  759. {
  760. "errorType":"error",
  761. "validationType":"expression",
  762. "expression":"INVERSIONCHECK(XAVG('ANNUAL_BASE', 'ANNUAL_BASE > 0','POS_CLASS'))",
  763. "errorGroup":"base_salary",
  764. "message":"Average annual salary wrong by position class",
  765. "parameter":"AGGREGATE_VALIDATION=Average annual salary;",
  766. "_id":"59ef3521626de51724712e23",
  767. "category":"pc_inversion",
  768. "dependentColumns":[
  769.  
  770. ]
  771. }
  772. ],
  773. "industries":[
  774.  
  775. ],
  776. "countries":[
  777.  
  778. ],
  779. "__v":0
  780. },
  781. {
  782. "_id":"59ef34f9626de5172470f515",
  783. "code":"ROLE_CH",
  784. "name":"Has this Incumbent Changed Role From Last Year?",
  785. "displayLabel":"Has this Incumbent Changed Role From Last Year?",
  786. "questionType":"text",
  787. "dataType":"string",
  788. "hidden":false,
  789. "updateDate":"2017-10-24T12:42:09.288Z",
  790. "type":"question",
  791. "tags":[
  792.  
  793. ],
  794. "validators":[
  795. {
  796. "errorType":"error",
  797. "validationType":"expression",
  798. "expression":"decode(isnotblank(this.ROLE_CH),decode(findin_set(this.ROLE_CH,'Y,N'),'true','false'),'false')",
  799. "errorGroup":"job_info",
  800. "message":"ROLE_CH value can not be null or empty",
  801. "_id":"59ef3521626de51724712e27",
  802. "category":"input_data",
  803. "dependentColumns":[
  804.  
  805. ]
  806. }
  807. ],
  808. "industries":[
  809.  
  810. ],
  811. "countries":[
  812.  
  813. ],
  814. "__v":0
  815. },
  816. {
  817. "_id":"59ef34f9626de5172470f516",
  818. "code":"HOL_ENT",
  819. "name":"Holiday entitlement (in days)",
  820. "displayLabel":"Holiday entitlement (in days)",
  821. "questionType":"integer",
  822. "dataType":"int",
  823. "hidden":false,
  824. "updateDate":"2017-10-24T12:42:09.292Z",
  825. "type":"question",
  826. "tags":[
  827.  
  828. ],
  829. "validators":[
  830.  
  831. ],
  832. "industries":[
  833.  
  834. ],
  835. "countries":[
  836.  
  837. ],
  838. "__v":0
  839. },
  840. {
  841. "_id":"59ef34f9626de5172470f517",
  842. "code":"TRANS_ALLOW",
  843. "name":"ANNUAL Transportation Allowance",
  844. "displayLabel":"ANNUAL Transportation Allowance",
  845. "questionType":"integer",
  846. "dataType":"int",
  847. "hidden":false,
  848. "updateDate":"2017-10-24T12:42:09.295Z",
  849. "type":"question",
  850. "tags":[
  851.  
  852. ],
  853. "validators":[
  854.  
  855. ],
  856. "industries":[
  857.  
  858. ],
  859. "countries":[
  860.  
  861. ],
  862. "__v":0
  863. },
  864. {
  865. "_id":"59ef34f9626de5172470f518",
  866. "code":"MEAL_ALLOW",
  867. "name":"ANNUAL Meal Allowance",
  868. "displayLabel":"ANNUAL Meal Allowance",
  869. "questionType":"integer",
  870. "dataType":"int",
  871. "hidden":false,
  872. "updateDate":"2017-10-24T12:42:09.299Z",
  873. "type":"question",
  874. "tags":[
  875.  
  876. ],
  877. "validators":[
  878.  
  879. ],
  880. "industries":[
  881.  
  882. ],
  883. "countries":[
  884.  
  885. ],
  886. "__v":0
  887. },
  888. {
  889. "_id":"59ef34f9626de5172470f519",
  890. "code":"SHIFT_ALLOW",
  891. "name":"ANNUAL Shift Allowance",
  892. "displayLabel":"ANNUAL Shift Allowance",
  893. "questionType":"integer",
  894. "dataType":"int",
  895. "hidden":false,
  896. "updateDate":"2017-10-24T12:42:09.302Z",
  897. "type":"question",
  898. "tags":[
  899.  
  900. ],
  901. "validators":[
  902.  
  903. ],
  904. "industries":[
  905.  
  906. ],
  907. "countries":[
  908.  
  909. ],
  910. "__v":0
  911. },
  912. {
  913. "_id":"59ef34f9626de5172470f51a",
  914. "code":"OTH_ALLOW",
  915. "name":"Other ANNUAL Guaranteed Allowance",
  916. "displayLabel":"Other ANNUAL Guaranteed Allowance",
  917. "questionType":"integer",
  918. "dataType":"int",
  919. "hidden":false,
  920. "updateDate":"2017-10-24T12:42:09.306Z",
  921. "type":"question",
  922. "tags":[
  923.  
  924. ],
  925. "validators":[
  926.  
  927. ],
  928. "industries":[
  929.  
  930. ],
  931. "countries":[
  932.  
  933. ],
  934. "__v":0
  935. },
  936. {
  937. "_id":"59ef34f9626de5172470f51b",
  938. "code":"BON_ELIG",
  939. "name":"Short-term Incentive (Variable Bonus) Eligibility Y/N",
  940. "displayLabel":"Short-term Incentive (Variable Bonus) Eligibility Y/N",
  941. "questionType":"text",
  942. "dataType":"string",
  943. "hidden":false,
  944. "updateDate":"2017-10-24T12:42:09.308Z",
  945. "type":"question",
  946. "tags":[
  947.  
  948. ],
  949. "validators":[
  950.  
  951. ],
  952. "industries":[
  953.  
  954. ],
  955. "countries":[
  956.  
  957. ],
  958. "__v":0
  959. },
  960. {
  961. "_id":"59ef34f9626de5172470f51c",
  962. "code":"BONUS_TPER",
  963. "name":"Short-term Incentive (Target) as Percentage of Base",
  964. "displayLabel":"Short-term Incentive (Target) as Percentage of Base",
  965. "questionType":"integer",
  966. "dataType":"int",
  967. "hidden":false,
  968. "updateDate":"2017-10-24T12:42:09.311Z",
  969. "type":"question",
  970. "tags":[
  971.  
  972. ],
  973. "validators":[
  974.  
  975. ],
  976. "industries":[
  977.  
  978. ],
  979. "countries":[
  980.  
  981. ],
  982. "__v":0
  983. },
  984. {
  985. "_id":"59ef34f9626de5172470f51d",
  986. "code":"MAXBON_TPER",
  987. "name":"Short-term Incentive (Maximum) as Percentage of Base",
  988. "displayLabel":"Short-term Incentive (Maximum) as Percentage of Base",
  989. "questionType":"integer",
  990. "dataType":"double",
  991. "hidden":false,
  992. "updateDate":"2017-10-24T12:42:09.314Z",
  993. "type":"question",
  994. "tags":[
  995.  
  996. ],
  997. "validators":[
  998.  
  999. ],
  1000. "industries":[
  1001.  
  1002. ],
  1003. "countries":[
  1004.  
  1005. ],
  1006. "__v":0
  1007. },
  1008. {
  1009. "_id":"59ef34f9626de5172470f51e",
  1010. "code":"BONUS_ACT",
  1011. "name":"Short Term Incentive over 2016 (Actual Excluding Mandatory Deferral)",
  1012. "displayLabel":"Short Term Incentive over 2016 (Actual Excluding Mandatory Deferral)",
  1013. "questionType":"integer",
  1014. "dataType":"int",
  1015. "hidden":false,
  1016. "updateDate":"2017-10-24T12:42:09.317Z",
  1017. "type":"question",
  1018. "tags":[
  1019.  
  1020. ],
  1021. "validators":[
  1022.  
  1023. ],
  1024. "industries":[
  1025.  
  1026. ],
  1027. "countries":[
  1028.  
  1029. ],
  1030. "__v":0
  1031. },
  1032. {
  1033. "_id":"59ef34f9626de5172470f51f",
  1034. "code":"COMM_ELIG",
  1035. "name":"Sales Incentive (incl. Commissions) Eligibility",
  1036. "displayLabel":"Sales Incentive (incl. Commissions) Eligibility",
  1037. "questionType":"text",
  1038. "dataType":"string",
  1039. "hidden":false,
  1040. "updateDate":"2017-10-24T12:42:09.319Z",
  1041. "type":"question",
  1042. "tags":[
  1043.  
  1044. ],
  1045. "validators":[
  1046.  
  1047. ],
  1048. "industries":[
  1049.  
  1050. ],
  1051. "countries":[
  1052.  
  1053. ],
  1054. "__v":0
  1055. },
  1056. {
  1057. "_id":"59ef34f9626de5172470f520",
  1058. "code":"COMM_TPER",
  1059. "name":"Sales Incentive (Target) as Percentage of Base",
  1060. "displayLabel":"Sales Incentive (Target) as Percentage of Base",
  1061. "questionType":"integer",
  1062. "dataType":"int",
  1063. "hidden":false,
  1064. "updateDate":"2017-10-24T12:42:09.322Z",
  1065. "type":"question",
  1066. "tags":[
  1067.  
  1068. ],
  1069. "validators":[
  1070.  
  1071. ],
  1072. "industries":[
  1073.  
  1074. ],
  1075. "countries":[
  1076.  
  1077. ],
  1078. "__v":0
  1079. },
  1080. {
  1081. "_id":"59ef34f9626de5172470f521",
  1082. "code":"COMM_ACT",
  1083. "name":"Sales Incentive (Actual)",
  1084. "displayLabel":"Sales Incentive (Actual)",
  1085. "questionType":"integer",
  1086. "dataType":"int",
  1087. "hidden":false,
  1088. "updateDate":"2017-10-24T12:42:09.324Z",
  1089. "type":"question",
  1090. "tags":[
  1091.  
  1092. ],
  1093. "validators":[
  1094.  
  1095. ],
  1096. "industries":[
  1097.  
  1098. ],
  1099. "countries":[
  1100.  
  1101. ],
  1102. "__v":0
  1103. },
  1104. {
  1105. "_id":"59ef34f9626de5172470f522",
  1106. "code":"OTH_BONUS",
  1107. "name":"Other Short Term Incentive over 2016 ",
  1108. "displayLabel":"Other Short Term Incentive over 2016 ",
  1109. "questionType":"integer",
  1110. "dataType":"int",
  1111. "hidden":false,
  1112. "updateDate":"2017-10-24T12:42:09.327Z",
  1113. "type":"question",
  1114. "tags":[
  1115.  
  1116. ],
  1117. "validators":[
  1118.  
  1119. ],
  1120. "industries":[
  1121.  
  1122. ],
  1123. "countries":[
  1124.  
  1125. ],
  1126. "__v":0
  1127. },
  1128. {
  1129. "_id":"59ef34f9626de5172470f523",
  1130. "code":"LTI_ELIG",
  1131. "name":"Long-term Incentive Eligibility",
  1132. "displayLabel":"Long-term Incentive Eligibility",
  1133. "questionType":"text",
  1134. "dataType":"string",
  1135. "hidden":false,
  1136. "updateDate":"2017-10-24T12:42:09.329Z",
  1137. "type":"question",
  1138. "tags":[
  1139.  
  1140. ],
  1141. "validators":[
  1142.  
  1143. ],
  1144. "industries":[
  1145.  
  1146. ],
  1147. "countries":[
  1148.  
  1149. ],
  1150. "__v":0
  1151. },
  1152. {
  1153. "_id":"59ef34f9626de5172470f524",
  1154. "code":"LTINAME_1",
  1155. "name":"LTI Plan Award #1 Organisation LTI Plan Identifier",
  1156. "displayLabel":"LTI Plan Award #1 Organisation LTI Plan Identifier",
  1157. "questionType":"text",
  1158. "dataType":"string",
  1159. "hidden":false,
  1160. "updateDate":"2017-10-24T12:42:09.333Z",
  1161. "type":"question",
  1162. "tags":[
  1163.  
  1164. ],
  1165. "validators":[
  1166.  
  1167. ],
  1168. "industries":[
  1169.  
  1170. ],
  1171. "countries":[
  1172.  
  1173. ],
  1174. "__v":0
  1175. },
  1176. {
  1177. "_id":"59ef34f9626de5172470f525",
  1178. "code":"LTISHARECASH_1",
  1179. "name":"Number of granted Options/ Shares/ Performance Units or value of granted Cash Award",
  1180. "displayLabel":"Number of granted Options/ Shares/ Performance Units or value of granted Cash Award",
  1181. "questionType":"text",
  1182. "dataType":"string",
  1183. "hidden":false,
  1184. "updateDate":"2017-10-24T12:42:09.336Z",
  1185. "type":"question",
  1186. "tags":[
  1187.  
  1188. ],
  1189. "validators":[
  1190.  
  1191. ],
  1192. "industries":[
  1193.  
  1194. ],
  1195. "countries":[
  1196.  
  1197. ],
  1198. "__v":0
  1199. },
  1200. {
  1201. "_id":"59ef34f9626de5172470f526",
  1202. "code":"LTINAME_2",
  1203. "name":"LTI Plan Award #2 Organisation LTI Plan Identifier",
  1204. "displayLabel":"LTI Plan Award #2 Organisation LTI Plan Identifier",
  1205. "questionType":"text",
  1206. "dataType":"string",
  1207. "hidden":false,
  1208. "updateDate":"2017-10-24T12:42:09.339Z",
  1209. "type":"question",
  1210. "tags":[
  1211.  
  1212. ],
  1213. "validators":[
  1214.  
  1215. ],
  1216. "industries":[
  1217.  
  1218. ],
  1219. "countries":[
  1220.  
  1221. ],
  1222. "__v":0
  1223. },
  1224. {
  1225. "_id":"59ef34f9626de5172470f527",
  1226. "code":"LTISHARECASH_2",
  1227. "name":"Number of granted Options/ Shares/ Performance Units or value of granted Cash Award",
  1228. "displayLabel":"Number of granted Options/ Shares/ Performance Units or value of granted Cash Award",
  1229. "questionType":"text",
  1230. "dataType":"string",
  1231. "hidden":false,
  1232. "updateDate":"2017-10-24T12:42:09.342Z",
  1233. "type":"question",
  1234. "tags":[
  1235.  
  1236. ],
  1237. "validators":[
  1238.  
  1239. ],
  1240. "industries":[
  1241.  
  1242. ],
  1243. "countries":[
  1244.  
  1245. ],
  1246. "__v":0
  1247. },
  1248. {
  1249. "_id":"59ef34f9626de5172470f528",
  1250. "code":"LTINAME_3",
  1251. "name":"LTI Plan Award #3 Organisation LTI Plan Identifier",
  1252. "displayLabel":"LTI Plan Award #3 Organisation LTI Plan Identifier",
  1253. "questionType":"text",
  1254. "dataType":"string",
  1255. "hidden":false,
  1256. "updateDate":"2017-10-24T12:42:09.345Z",
  1257. "type":"question",
  1258. "tags":[
  1259.  
  1260. ],
  1261. "validators":[
  1262.  
  1263. ],
  1264. "industries":[
  1265.  
  1266. ],
  1267. "countries":[
  1268.  
  1269. ],
  1270. "__v":0
  1271. },
  1272. {
  1273. "_id":"59ef34f9626de5172470f529",
  1274. "code":"LTISHARECASH_3",
  1275. "name":"Number of granted Options/ Shares/ Performance Units or value of granted Cash Award",
  1276. "displayLabel":"Number of granted Options/ Shares/ Performance Units or value of granted Cash Award",
  1277. "questionType":"text",
  1278. "dataType":"string",
  1279. "hidden":false,
  1280. "updateDate":"2017-10-24T12:42:09.348Z",
  1281. "type":"question",
  1282. "tags":[
  1283.  
  1284. ],
  1285. "validators":[
  1286.  
  1287. ],
  1288. "industries":[
  1289.  
  1290. ],
  1291. "countries":[
  1292.  
  1293. ],
  1294. "__v":0
  1295. },
  1296. {
  1297. "_id":"59ef34f9626de5172470f52a",
  1298. "code":"CAR_BEN_TYPE",
  1299. "name":"Type of Company Car Benefit",
  1300. "displayLabel":" Type of Company Car Benefit",
  1301. "questionType":"text",
  1302. "dataType":"string",
  1303. "hidden":false,
  1304. "updateDate":"2017-10-24T12:42:09.351Z",
  1305. "type":"question",
  1306. "tags":[
  1307.  
  1308. ],
  1309. "validators":[
  1310.  
  1311. ],
  1312. "industries":[
  1313.  
  1314. ],
  1315. "countries":[
  1316.  
  1317. ],
  1318. "__v":0
  1319. },
  1320. {
  1321. "_id":"59ef34f9626de5172470f52b",
  1322. "code":"CAR_ALLOW",
  1323. "name":"ANNUAL Allowance in Lieu of a Company Car",
  1324. "displayLabel":" ANNUAL Allowance in Lieu of a Company Car",
  1325. "questionType":"integer",
  1326. "dataType":"int",
  1327. "hidden":false,
  1328. "updateDate":"2017-10-24T12:42:09.354Z",
  1329. "type":"question",
  1330. "tags":[
  1331.  
  1332. ],
  1333. "validators":[
  1334.  
  1335. ],
  1336. "industries":[
  1337.  
  1338. ],
  1339. "countries":[
  1340.  
  1341. ],
  1342. "__v":0
  1343. },
  1344. {
  1345. "_id":"59ef34f9626de5172470f52c",
  1346. "code":"CAR_LISTPRICE",
  1347. "name":"List Price (incl. VAT)",
  1348. "displayLabel":" List Price (incl. VAT)",
  1349. "questionType":"integer",
  1350. "dataType":"int",
  1351. "hidden":false,
  1352. "updateDate":"2017-10-24T12:42:09.357Z",
  1353. "type":"question",
  1354. "tags":[
  1355.  
  1356. ],
  1357. "validators":[
  1358.  
  1359. ],
  1360. "industries":[
  1361.  
  1362. ],
  1363. "countries":[
  1364.  
  1365. ],
  1366. "__v":0
  1367. },
  1368. {
  1369. "_id":"59ef34f9626de5172470f52d",
  1370. "code":"CAR_MLEASE",
  1371. "name":"Monthly Lease Cost (incl. VAT)",
  1372. "displayLabel":" Monthly Lease Cost (incl. VAT)",
  1373. "questionType":"integer",
  1374. "dataType":"int",
  1375. "hidden":false,
  1376. "updateDate":"2017-10-24T12:42:09.360Z",
  1377. "type":"question",
  1378. "tags":[
  1379.  
  1380. ],
  1381. "validators":[
  1382.  
  1383. ],
  1384. "industries":[
  1385.  
  1386. ],
  1387. "countries":[
  1388.  
  1389. ],
  1390. "__v":0
  1391. },
  1392. {
  1393. "_id":"59ef34f9626de5172470f52e",
  1394. "code":"CAR_REPL",
  1395. "name":"Replacement Term (in Years)",
  1396. "displayLabel":"Replacement Term (in Years)",
  1397. "questionType":"integer",
  1398. "dataType":"int",
  1399. "hidden":false,
  1400. "updateDate":"2017-10-24T12:42:09.362Z",
  1401. "type":"question",
  1402. "tags":[
  1403.  
  1404. ],
  1405. "validators":[
  1406.  
  1407. ],
  1408. "industries":[
  1409.  
  1410. ],
  1411. "countries":[
  1412.  
  1413. ],
  1414. "__v":0
  1415. },
  1416. {
  1417. "_id":"59ef34f9626de5172470f52f",
  1418. "code":"CAR_FUEL",
  1419. "name":"Fuel for private use paid by organisation (%)",
  1420. "displayLabel":" Fuel for private use paid by organisation (%)",
  1421. "questionType":"checkboxes",
  1422. "dataType":"string",
  1423. "options":{
  1424. "items":[
  1425. {
  1426. "value":"option1",
  1427. "displayName":"Option1"
  1428. },
  1429. {
  1430. "value":"option2",
  1431. "displayName":"Option2"
  1432. },
  1433. {
  1434. "value":"option3",
  1435. "displayName":"Option3"
  1436. },
  1437. {
  1438. "value":"option4",
  1439. "displayName":"Option4"
  1440. }
  1441. ],
  1442. "questionsAnswers":[
  1443.  
  1444. ]
  1445. },
  1446. "hidden":false,
  1447. "updateDate":"2017-10-24T12:42:09.365Z",
  1448. "type":"question",
  1449. "tags":[
  1450.  
  1451. ],
  1452. "validators":[
  1453. {
  1454. "errorType":"error",
  1455. "validationType":"expression",
  1456. "expression":"decode(length({this.CAR_FUEL}) < 2, 'true', 'false')",
  1457. "errorGroup":"job_info",
  1458. "message":"CAR_FUEL please choose two options at least",
  1459. "_id":"59ef3521626de51724712e28",
  1460. "category":"input_data",
  1461. "dependentColumns":[
  1462.  
  1463. ]
  1464. }
  1465. ],
  1466. "industries":[
  1467.  
  1468. ],
  1469. "countries":[
  1470.  
  1471. ],
  1472. "__v":0
  1473. }
  1474. ]
  1475. }
  1476. ],
  1477. "companies":[
  1478. {
  1479. "_id":"5a12ee2145abfe1b20c986cb",
  1480. "publicallyTraded":false,
  1481. "name":"dsagtyg",
  1482. "country":"AT",
  1483. "organizationProfileId":"5a12ee0bcde4550f9c769b10",
  1484. "active":true,
  1485. "industries":[
  1486. {
  1487. "superSector":"TR",
  1488. "sector":"115"
  1489. }
  1490. ],
  1491. "questions":[
  1492. {
  1493. "_id":"59ef34f9626de5172470f500",
  1494. "code":"YOUR_EEID",
  1495. "name":"Employee Identifier",
  1496. "displayLabel":"Employee Identifier",
  1497. "questionType":"integer",
  1498. "dataType":"int",
  1499. "hidden":false,
  1500. "updateDate":"2017-10-24T12:42:09.170Z",
  1501. "type":"question",
  1502. "tags":[
  1503.  
  1504. ],
  1505. "validators":[
  1506. {
  1507. "errorType":"error",
  1508. "validationType":"expression",
  1509. "expression":"isnotblank(this.YOUR_EEID)",
  1510. "errorGroup":"base_salary",
  1511. "message":"YOUR_EEID value can not be null or empty",
  1512. "_id":"59ef3521626de51724712e15",
  1513. "category":"input_data",
  1514. "dependentColumns":[
  1515.  
  1516. ]
  1517. }
  1518. ],
  1519. "industries":[
  1520.  
  1521. ],
  1522. "countries":[
  1523.  
  1524. ],
  1525. "__v":0
  1526. },
  1527. {
  1528. "_id":"59ef34f9626de5172470f501",
  1529. "code":"REV_RESP",
  1530. "name":"Revenue for business in which role sits (in millions EUR)",
  1531. "displayLabel":"Revenue for business in which role sits (in millions EUR)",
  1532. "questionType":"integer",
  1533. "dataType":"int",
  1534. "hidden":false,
  1535. "updateDate":"2017-10-24T12:42:09.189Z",
  1536. "type":"question",
  1537. "tags":[
  1538.  
  1539. ],
  1540. "validators":[
  1541.  
  1542. ],
  1543. "industries":[
  1544.  
  1545. ],
  1546. "countries":[
  1547.  
  1548. ],
  1549. "__v":0
  1550. },
  1551. {
  1552. "_id":"59ef34f9626de5172470f502",
  1553. "code":"BIRTH_YEAR",
  1554. "name":"Year of Birth",
  1555. "displayLabel":"Year of Birth",
  1556. "questionType":"integer",
  1557. "dataType":"int",
  1558. "hidden":false,
  1559. "updateDate":"2017-10-24T12:42:09.199Z",
  1560. "type":"question",
  1561. "tags":[
  1562.  
  1563. ],
  1564. "validators":[
  1565. {
  1566. "errorType":"error",
  1567. "validationType":"expression",
  1568. "expression":"decode(this.BIRTH_YEAR >= 1940,decode(this.BIRTH_YEAR <= 2000,'true','false'),'false')",
  1569. "errorGroup":"job_info",
  1570. "message":"BIRTH_YEAR value is invalid",
  1571. "_id":"59ef3521626de51724712e16",
  1572. "category":"input_data",
  1573. "dependentColumns":[
  1574.  
  1575. ]
  1576. }
  1577. ],
  1578. "industries":[
  1579.  
  1580. ],
  1581. "countries":[
  1582.  
  1583. ],
  1584. "__v":0
  1585. },
  1586. {
  1587. "_id":"59ef34f9626de5172470f503",
  1588. "code":"HIRE_YEAR",
  1589. "name":"Year of Hire",
  1590. "displayLabel":"Year of Hire",
  1591. "questionType":"integer",
  1592. "dataType":"int",
  1593. "hidden":false,
  1594. "updateDate":"2017-10-24T12:42:09.206Z",
  1595. "type":"question",
  1596. "tags":[
  1597.  
  1598. ],
  1599. "validators":[
  1600. {
  1601. "errorType":"error",
  1602. "validationType":"expression",
  1603. "expression":"decode (this.HIRE_YEAR > 1950,decode(this.HIRE_YEAR < 2017,'true','false'),'false')",
  1604. "errorGroup":"job_info",
  1605. "message":"HIRE_YEAR value is invalid",
  1606. "_id":"59ef3521626de51724712e17",
  1607. "category":"input_data",
  1608. "dependentColumns":[
  1609.  
  1610. ]
  1611. }
  1612. ],
  1613. "industries":[
  1614.  
  1615. ],
  1616. "countries":[
  1617.  
  1618. ],
  1619. "__v":0
  1620. },
  1621. {
  1622. "_id":"59ef34f9626de5172470f504",
  1623. "code":"GENDER_CODE",
  1624. "name":"Gender",
  1625. "displayLabel":"Gender",
  1626. "questionType":"text",
  1627. "dataType":"string",
  1628. "hidden":false,
  1629. "updateDate":"2017-10-24T12:42:09.212Z",
  1630. "type":"question",
  1631. "tags":[
  1632.  
  1633. ],
  1634. "validators":[
  1635. {
  1636. "errorType":"error",
  1637. "validationType":"expression",
  1638. "expression":"decode(findin_set(this.GENDER_CODE,'M,F'), 'false', 'true')",
  1639. "errorGroup":"job_info",
  1640. "message":"GENDER_CODE value is invalid",
  1641. "_id":"59ef3521626de51724712e18",
  1642. "category":"input_data",
  1643. "dependentColumns":[
  1644.  
  1645. ]
  1646. }
  1647. ],
  1648. "industries":[
  1649.  
  1650. ],
  1651. "countries":[
  1652.  
  1653. ],
  1654. "__v":0
  1655. },
  1656. {
  1657. "_id":"59ef34f9626de5172470f505",
  1658. "code":"REG_CODE_ORIG",
  1659. "name":"Region in which role is located",
  1660. "displayLabel":"Region in which role is located",
  1661. "questionType":"text",
  1662. "dataType":"string",
  1663. "hidden":false,
  1664. "updateDate":"2017-10-24T12:42:09.216Z",
  1665. "type":"question",
  1666. "tags":[
  1667.  
  1668. ],
  1669. "validators":[
  1670. {
  1671. "errorType":"error",
  1672. "validationType":"expression",
  1673. "expression":"decode(findin_set(this.REG_CODE_ORIG,'West London,London,East London'), 'false', 'true')",
  1674. "errorGroup":"job_info",
  1675. "message":"REG_CODE_ORIG value is invalid",
  1676. "_id":"59ef3521626de51724712e19",
  1677. "category":"input_data",
  1678. "dependentColumns":[
  1679.  
  1680. ]
  1681. }
  1682. ],
  1683. "industries":[
  1684.  
  1685. ],
  1686. "countries":[
  1687.  
  1688. ],
  1689. "__v":0
  1690. },
  1691. {
  1692. "_id":"59ef34f9626de5172470f506",
  1693. "code":"YOUR_TITLE",
  1694. "name":"Organisation Job Title",
  1695. "displayLabel":"Organisation Job Title",
  1696. "questionType":"text",
  1697. "dataType":"string",
  1698. "hidden":false,
  1699. "updateDate":"2017-10-24T12:42:09.220Z",
  1700. "type":"question",
  1701. "tags":[
  1702.  
  1703. ],
  1704. "validators":[
  1705. {
  1706. "errorType":"error",
  1707. "validationType":"expression",
  1708. "expression":"isnotblank(this.YOUR_TITLE)",
  1709. "errorGroup":"base_salary",
  1710. "message":"YOUR_TITLE value can not be null or empty",
  1711. "_id":"59ef3521626de51724712e1a",
  1712. "category":"input_data",
  1713. "dependentColumns":[
  1714.  
  1715. ]
  1716. }
  1717. ],
  1718. "industries":[
  1719.  
  1720. ],
  1721. "countries":[
  1722.  
  1723. ],
  1724. "__v":0
  1725. },
  1726. {
  1727. "_id":"59ef34f9626de5172470f507",
  1728. "code":"POS_CODE",
  1729. "name":"Mercer Universal Position Code (MUPCS®)",
  1730. "displayLabel":"Mercer Universal Position Code (MUPCS®)",
  1731. "questionType":"text",
  1732. "dataType":"string",
  1733. "hidden":false,
  1734. "updateDate":"2017-10-24T12:42:09.223Z",
  1735. "type":"question",
  1736. "tags":[
  1737.  
  1738. ],
  1739. "validators":[
  1740. {
  1741. "errorType":"error",
  1742. "validationType":"expression",
  1743. "expression":"isnotblank(this.POS_CODE)",
  1744. "errorGroup":"job_info",
  1745. "message":"POS_CODE value can not be null or empty",
  1746. "_id":"59ef3521626de51724712e1b",
  1747. "category":"input_data",
  1748. "dependentColumns":[
  1749.  
  1750. ]
  1751. }
  1752. ],
  1753. "industries":[
  1754.  
  1755. ],
  1756. "countries":[
  1757.  
  1758. ],
  1759. "__v":0
  1760. },
  1761. {
  1762. "_id":"59ef34f9626de5172470f508",
  1763. "code":"RPTSTO",
  1764. "displayLabel":"Organisation's Reports to Position Title",
  1765. "name":"Organisation's Reports to Position Title",
  1766. "questionType":"text",
  1767. "dataType":"string",
  1768. "hidden":false,
  1769. "updateDate":"2017-10-24T12:42:09.228Z",
  1770. "type":"question",
  1771. "tags":[
  1772.  
  1773. ],
  1774. "validators":[
  1775.  
  1776. ],
  1777. "industries":[
  1778.  
  1779. ],
  1780. "countries":[
  1781.  
  1782. ],
  1783. "__v":0
  1784. },
  1785. {
  1786. "_id":"59ef34f9626de5172470f509",
  1787. "code":"YOUR_CODE",
  1788. "name":"Organisation Job Code (Optional)",
  1789. "displayLabel":"Organisation Job Code (Optional)",
  1790. "questionType":"text",
  1791. "dataType":"string",
  1792. "hidden":false,
  1793. "updateDate":"2017-10-24T12:42:09.231Z",
  1794. "type":"question",
  1795. "tags":[
  1796.  
  1797. ],
  1798. "validators":[
  1799.  
  1800. ],
  1801. "industries":[
  1802.  
  1803. ],
  1804. "countries":[
  1805.  
  1806. ],
  1807. "__v":0
  1808. },
  1809. {
  1810. "_id":"59ef34f9626de5172470f50a",
  1811. "code":"YOUR_LEVEL",
  1812. "name":"Organisation Job Level (Optional)",
  1813. "displayLabel":"Organisation Job Level (Optional)",
  1814. "questionType":"text",
  1815. "dataType":"string",
  1816. "hidden":false,
  1817. "updateDate":"2017-10-24T12:42:09.233Z",
  1818. "type":"question",
  1819. "tags":[
  1820.  
  1821. ],
  1822. "validators":[
  1823.  
  1824. ],
  1825. "industries":[
  1826.  
  1827. ],
  1828. "countries":[
  1829.  
  1830. ],
  1831. "__v":0
  1832. },
  1833. {
  1834. "_id":"59ef34f9626de5172470f50b",
  1835. "code":"YOUR_GRADE",
  1836. "name":"Organisation Job Grade (Optional)",
  1837. "displayLabel":"Organisation Job Grade (Optional)",
  1838. "questionType":"integer",
  1839. "dataType":"int",
  1840. "hidden":false,
  1841. "updateDate":"2017-10-24T12:42:09.236Z",
  1842. "type":"question",
  1843. "tags":[
  1844.  
  1845. ],
  1846. "validators":[
  1847.  
  1848. ],
  1849. "industries":[
  1850.  
  1851. ],
  1852. "countries":[
  1853.  
  1854. ],
  1855. "__v":0
  1856. },
  1857. {
  1858. "_id":"59ef34f9626de5172470f50c",
  1859. "code":"YOUR_OTHER",
  1860. "name":"Organisation Job ID - Other",
  1861. "displayLabel":"Organisation Job ID - Other",
  1862. "questionType":"integer",
  1863. "dataType":"int",
  1864. "hidden":false,
  1865. "updateDate":"2017-10-24T12:42:09.240Z",
  1866. "type":"question",
  1867. "tags":[
  1868.  
  1869. ],
  1870. "validators":[
  1871.  
  1872. ],
  1873. "industries":[
  1874.  
  1875. ],
  1876. "countries":[
  1877.  
  1878. ],
  1879. "__v":0
  1880. },
  1881. {
  1882. "_id":"59ef34f9626de5172470f50d",
  1883. "code":"THERA_FLAG",
  1884. "name":"Therapeutic Area Flag",
  1885. "displayLabel":"Therapeutic Area Flag",
  1886. "questionType":"integer",
  1887. "dataType":"int",
  1888. "hidden":false,
  1889. "updateDate":"2017-10-24T12:42:09.245Z",
  1890. "type":"question",
  1891. "tags":[
  1892.  
  1893. ],
  1894. "validators":[
  1895.  
  1896. ],
  1897. "industries":[
  1898.  
  1899. ],
  1900. "countries":[
  1901.  
  1902. ],
  1903. "__v":0
  1904. },
  1905. {
  1906. "_id":"59ef34f9626de5172470f50e",
  1907. "code":"POS_CLASS",
  1908. "name":"IPE Position Class (current year)",
  1909. "displayLabel":"IPE Position Class (current year)",
  1910. "questionType":"integer",
  1911. "dataType":"int",
  1912. "hidden":false,
  1913. "updateDate":"2017-10-24T12:42:09.247Z",
  1914. "type":"question",
  1915. "tags":[
  1916.  
  1917. ],
  1918. "validators":[
  1919. {
  1920. "errorType":"error",
  1921. "validationType":"expression",
  1922. "expression":"decode(this.POS_CLASS < 40,'false',decode(this.POS_CLASS > 84,'false','true'))",
  1923. "errorGroup":"job_info",
  1924. "message":"POS_CLASS value is invalid",
  1925. "_id":"59ef3521626de51724712e1c",
  1926. "category":"input_data",
  1927. "dependentColumns":[
  1928.  
  1929. ]
  1930. }
  1931. ],
  1932. "industries":[
  1933.  
  1934. ],
  1935. "countries":[
  1936.  
  1937. ],
  1938. "__v":0
  1939. },
  1940. {
  1941. "_id":"59ef34f9626de5172470f50f",
  1942. "code":"POS_CLASS_ADJUST",
  1943. "name":"IPE Position Class when adjusted",
  1944. "displayLabel":"IPE Position Class when adjusted",
  1945. "questionType":"integer",
  1946. "dataType":"int",
  1947. "hidden":false,
  1948. "updateDate":"2017-10-24T12:42:09.262Z",
  1949. "type":"question",
  1950. "tags":[
  1951.  
  1952. ],
  1953. "validators":[
  1954. {
  1955. "errorType":"error",
  1956. "validationType":"expression",
  1957. "expression":"decode(this.POS_CLASS_ADJUST < 40,'false',decode(this.POS_CLASS_ADJUST > 84,'false','true'))",
  1958. "errorGroup":"job_info",
  1959. "message":"POS_CLASS_ADJUST value is invalid",
  1960. "_id":"59ef3521626de51724712e1d",
  1961. "category":"input_data",
  1962. "dependentColumns":[
  1963.  
  1964. ]
  1965. }
  1966. ],
  1967. "industries":[
  1968.  
  1969. ],
  1970. "countries":[
  1971.  
  1972. ],
  1973. "__v":0
  1974. },
  1975. {
  1976. "_id":"59ef34f9626de5172470f510",
  1977. "code":"REGION_RESP",
  1978. "name":"Geographic Scope of Role",
  1979. "displayLabel":"Geographic Scope of Role",
  1980. "questionType":"dropdown",
  1981. "dataType":"string",
  1982. "options":{
  1983. "items":[
  1984. {
  1985. "value":"70_in_country",
  1986. "displayName":"70 - In Country"
  1987. },
  1988. {
  1989. "value":"10_global",
  1990. "displayName":"10 - Global"
  1991. },
  1992. {
  1993. "value":"20_multi_regional",
  1994. "displayName":"20 - Multi Regional (2-5 regions)"
  1995. },
  1996. {
  1997. "value":"30_regional",
  1998. "displayName":"30 - Regional (e.g. Europe)"
  1999. }
  2000. ],
  2001. "questionsAnswers":[
  2002.  
  2003. ]
  2004. },
  2005. "hidden":false,
  2006. "updateDate":"2017-10-24T12:42:09.267Z",
  2007. "type":"question",
  2008. "tags":[
  2009.  
  2010. ],
  2011. "validators":[
  2012. {
  2013. "errorType":"error",
  2014. "validationType":"expression",
  2015. "expression":"decode(findin_set(this.REGION_RESP,'70 - In Country,10 - Global,20 - Multi Regional (2-5 regions),30 - Regional (e.g. Europe)'), 'false', 'true')",
  2016. "errorGroup":"job_info",
  2017. "message":"REGION_RESP value is invalid",
  2018. "_id":"59ef3521626de51724712e1e",
  2019. "category":"input_data",
  2020. "dependentColumns":[
  2021.  
  2022. ]
  2023. }
  2024. ],
  2025. "industries":[
  2026.  
  2027. ],
  2028. "countries":[
  2029.  
  2030. ],
  2031. "__v":0
  2032. },
  2033. {
  2034. "_id":"59ef34f9626de5172470f511",
  2035. "code":"CURR_CODE",
  2036. "name":"Currency Code",
  2037. "displayLabel":"Currency Code",
  2038. "questionType":"text",
  2039. "dataType":"string",
  2040. "hidden":false,
  2041. "updateDate":"2017-10-24T12:42:09.273Z",
  2042. "type":"question",
  2043. "tags":[
  2044.  
  2045. ],
  2046. "validators":[
  2047.  
  2048. ],
  2049. "industries":[
  2050.  
  2051. ],
  2052. "countries":[
  2053.  
  2054. ],
  2055. "__v":0
  2056. },
  2057. {
  2058. "_id":"59ef34f9626de5172470f512",
  2059. "code":"MONTH_BASE",
  2060. "name":"Monthly Base Salary (Equivalent to 100% work time)",
  2061. "displayLabel":"Monthly Base Salary (Equivalent to 100% work time)",
  2062. "questionType":"integer",
  2063. "dataType":"int",
  2064. "hidden":false,
  2065. "updateDate":"2017-10-24T12:42:09.276Z",
  2066. "type":"question",
  2067. "tags":[
  2068.  
  2069. ],
  2070. "validators":[
  2071. {
  2072. "errorType":"error",
  2073. "validationType":"expression",
  2074. "expression":"AGGREGATERANGECHECK(XAVG('MONTH_BASE', 'MONTH_BASE >= 10' , 'POS_CODE'), LOOKUPMAP(exadel_pos_code, '', 'POS_CODE','AVG_MONTH_BASE'), '>=')",
  2075. "errorGroup":"base_salary",
  2076. "message":"Average month salary is wrong",
  2077. "parameter":"AGGREGATE_VALIDATION=Average month salary;",
  2078. "_id":"59ef3521626de51724712e21",
  2079. "category":"job_aggregate",
  2080. "dependentColumns":[
  2081.  
  2082. ]
  2083. },
  2084. {
  2085. "errorType":"error",
  2086. "validationType":"expression",
  2087. "expression":"AGGREGATERANGECHECK(XAVG('MONTH_BASE', 'MONTH_BASE >= 10' , 'POS_CLASS'), LOOKUPMAP(exadel_pos_class, '', 'POS_CLASS','AVG_MONTH_BASE'), '>=')",
  2088. "errorGroup":"base_salary",
  2089. "message":"Average month salary is wrong",
  2090. "parameter":"AGGREGATE_VALIDATION=Average month salary;",
  2091. "_id":"59ef3521626de51724712e20",
  2092. "category":"pc_aggregate",
  2093. "dependentColumns":[
  2094.  
  2095. ]
  2096. },
  2097. {
  2098. "errorType":"error",
  2099. "validationType":"expression",
  2100. "expression":"INVERSIONCHECK(XAVG('MONTH_BASE', 'MONTH_BASE > 0','POS_CLASS'))",
  2101. "errorGroup":"base_salary",
  2102. "message":"Average month salary wrong by position class",
  2103. "parameter":"AGGREGATE_VALIDATION=Average month salary;",
  2104. "_id":"59ef3521626de51724712e1f",
  2105. "category":"pc_inversion",
  2106. "dependentColumns":[
  2107.  
  2108. ]
  2109. }
  2110. ],
  2111. "industries":[
  2112.  
  2113. ],
  2114. "countries":[
  2115.  
  2116. ],
  2117. "__v":0
  2118. },
  2119. {
  2120. "_id":"59ef34f9626de5172470f513",
  2121. "code":"NUM_MONTH",
  2122. "name":"Number of Months Paid",
  2123. "displayLabel":"Number of Months Paid",
  2124. "questionType":"integer",
  2125. "dataType":"int",
  2126. "hidden":false,
  2127. "updateDate":"2017-10-24T12:42:09.280Z",
  2128. "type":"question",
  2129. "tags":[
  2130.  
  2131. ],
  2132. "validators":[
  2133. {
  2134. "errorType":"autocorrect",
  2135. "validationType":"expression",
  2136. "expression":"decode(this.NUM_MONTH < 1, '1', decode(this.NUM_MONTH > 12, '12', this.NUM_MONTH))",
  2137. "errorGroup":"base_salary",
  2138. "message":"NUM_MONTH value can not be null or empty",
  2139. "_id":"59ef3521626de51724712e22",
  2140. "category":"input_data",
  2141. "dependentColumns":[
  2142.  
  2143. ]
  2144. }
  2145. ],
  2146. "industries":[
  2147.  
  2148. ],
  2149. "countries":[
  2150.  
  2151. ],
  2152. "__v":0
  2153. },
  2154. {
  2155. "_id":"59ef34f9626de5172470f514",
  2156. "code":"ANNUAL_BASE",
  2157. "name":"Annual Base Salary (Equivalent to 100% work time)",
  2158. "displayLabel":"Annual Base Salary (Equivalent to 100% work time)",
  2159. "questionType":"integer",
  2160. "dataType":"int",
  2161. "hidden":false,
  2162. "updateDate":"2017-10-24T12:42:09.284Z",
  2163. "type":"question",
  2164. "tags":[
  2165.  
  2166. ],
  2167. "validators":[
  2168. {
  2169. "errorType":"error",
  2170. "validationType":"expression",
  2171. "expression":"decode(this.ANNUAL_BASE > 1000000,false,true)",
  2172. "errorGroup":"base_salary",
  2173. "message":"ANNUAL_BASE value can not be null or empty",
  2174. "_id":"59ef3521626de51724712e26",
  2175. "category":"input_data",
  2176. "dependentColumns":[
  2177.  
  2178. ]
  2179. },
  2180. {
  2181. "errorType":"error",
  2182. "validationType":"expression",
  2183. "expression":"AGGREGATERANGECHECK(XAVG('ANNUAL_BASE', 'ANNUAL_BASE >= 10' , 'POS_CODE'), LOOKUPMAP(exadel_pos_code, '', 'POS_CODE','AVG_ANNUAL_BASE'), '>=')",
  2184. "errorGroup":"base_salary",
  2185. "message":"Average annual salary is wrong",
  2186. "parameter":"AGGREGATE_VALIDATION=Average annual salary;",
  2187. "_id":"59ef3521626de51724712e25",
  2188. "category":"job_aggregate",
  2189. "dependentColumns":[
  2190.  
  2191. ]
  2192. },
  2193. {
  2194. "errorType":"error",
  2195. "validationType":"expression",
  2196. "expression":"AGGREGATERANGECHECK(XAVG('ANNUAL_BASE', 'ANNUAL_BASE >= 10' , 'POS_CLASS'), LOOKUPMAP(exadel_pos_class, '', 'POS_CLASS','AVG_ANNUAL_BASE'), '>=')",
  2197. "errorGroup":"base_salary",
  2198. "message":"Average annual salary is wrong",
  2199. "parameter":"AGGREGATE_VALIDATION=Average annual salary;",
  2200. "_id":"59ef3521626de51724712e24",
  2201. "category":"pc_aggregate",
  2202. "dependentColumns":[
  2203.  
  2204. ]
  2205. },
  2206. {
  2207. "errorType":"error",
  2208. "validationType":"expression",
  2209. "expression":"INVERSIONCHECK(XAVG('ANNUAL_BASE', 'ANNUAL_BASE > 0','POS_CLASS'))",
  2210. "errorGroup":"base_salary",
  2211. "message":"Average annual salary wrong by position class",
  2212. "parameter":"AGGREGATE_VALIDATION=Average annual salary;",
  2213. "_id":"59ef3521626de51724712e23",
  2214. "category":"pc_inversion",
  2215. "dependentColumns":[
  2216.  
  2217. ]
  2218. }
  2219. ],
  2220. "industries":[
  2221.  
  2222. ],
  2223. "countries":[
  2224.  
  2225. ],
  2226. "__v":0
  2227. },
  2228. {
  2229. "_id":"59ef34f9626de5172470f515",
  2230. "code":"ROLE_CH",
  2231. "name":"Has this Incumbent Changed Role From Last Year?",
  2232. "displayLabel":"Has this Incumbent Changed Role From Last Year?",
  2233. "questionType":"text",
  2234. "dataType":"string",
  2235. "hidden":false,
  2236. "updateDate":"2017-10-24T12:42:09.288Z",
  2237. "type":"question",
  2238. "tags":[
  2239.  
  2240. ],
  2241. "validators":[
  2242. {
  2243. "errorType":"error",
  2244. "validationType":"expression",
  2245. "expression":"decode(isnotblank(this.ROLE_CH),decode(findin_set(this.ROLE_CH,'Y,N'),'true','false'),'false')",
  2246. "errorGroup":"job_info",
  2247. "message":"ROLE_CH value can not be null or empty",
  2248. "_id":"59ef3521626de51724712e27",
  2249. "category":"input_data",
  2250. "dependentColumns":[
  2251.  
  2252. ]
  2253. }
  2254. ],
  2255. "industries":[
  2256.  
  2257. ],
  2258. "countries":[
  2259.  
  2260. ],
  2261. "__v":0
  2262. },
  2263. {
  2264. "_id":"59ef34f9626de5172470f516",
  2265. "code":"HOL_ENT",
  2266. "name":"Holiday entitlement (in days)",
  2267. "displayLabel":"Holiday entitlement (in days)",
  2268. "questionType":"integer",
  2269. "dataType":"int",
  2270. "hidden":false,
  2271. "updateDate":"2017-10-24T12:42:09.292Z",
  2272. "type":"question",
  2273. "tags":[
  2274.  
  2275. ],
  2276. "validators":[
  2277.  
  2278. ],
  2279. "industries":[
  2280.  
  2281. ],
  2282. "countries":[
  2283.  
  2284. ],
  2285. "__v":0
  2286. },
  2287. {
  2288. "_id":"59ef34f9626de5172470f517",
  2289. "code":"TRANS_ALLOW",
  2290. "name":"ANNUAL Transportation Allowance",
  2291. "displayLabel":"ANNUAL Transportation Allowance",
  2292. "questionType":"integer",
  2293. "dataType":"int",
  2294. "hidden":false,
  2295. "updateDate":"2017-10-24T12:42:09.295Z",
  2296. "type":"question",
  2297. "tags":[
  2298.  
  2299. ],
  2300. "validators":[
  2301.  
  2302. ],
  2303. "industries":[
  2304.  
  2305. ],
  2306. "countries":[
  2307.  
  2308. ],
  2309. "__v":0
  2310. },
  2311. {
  2312. "_id":"59ef34f9626de5172470f518",
  2313. "code":"MEAL_ALLOW",
  2314. "name":"ANNUAL Meal Allowance",
  2315. "displayLabel":"ANNUAL Meal Allowance",
  2316. "questionType":"integer",
  2317. "dataType":"int",
  2318. "hidden":false,
  2319. "updateDate":"2017-10-24T12:42:09.299Z",
  2320. "type":"question",
  2321. "tags":[
  2322.  
  2323. ],
  2324. "validators":[
  2325.  
  2326. ],
  2327. "industries":[
  2328.  
  2329. ],
  2330. "countries":[
  2331.  
  2332. ],
  2333. "__v":0
  2334. },
  2335. {
  2336. "_id":"59ef34f9626de5172470f519",
  2337. "code":"SHIFT_ALLOW",
  2338. "name":"ANNUAL Shift Allowance",
  2339. "displayLabel":"ANNUAL Shift Allowance",
  2340. "questionType":"integer",
  2341. "dataType":"int",
  2342. "hidden":false,
  2343. "updateDate":"2017-10-24T12:42:09.302Z",
  2344. "type":"question",
  2345. "tags":[
  2346.  
  2347. ],
  2348. "validators":[
  2349.  
  2350. ],
  2351. "industries":[
  2352.  
  2353. ],
  2354. "countries":[
  2355.  
  2356. ],
  2357. "__v":0
  2358. },
  2359. {
  2360. "_id":"59ef34f9626de5172470f51a",
  2361. "code":"OTH_ALLOW",
  2362. "name":"Other ANNUAL Guaranteed Allowance",
  2363. "displayLabel":"Other ANNUAL Guaranteed Allowance",
  2364. "questionType":"integer",
  2365. "dataType":"int",
  2366. "hidden":false,
  2367. "updateDate":"2017-10-24T12:42:09.306Z",
  2368. "type":"question",
  2369. "tags":[
  2370.  
  2371. ],
  2372. "validators":[
  2373.  
  2374. ],
  2375. "industries":[
  2376.  
  2377. ],
  2378. "countries":[
  2379.  
  2380. ],
  2381. "__v":0
  2382. },
  2383. {
  2384. "_id":"59ef34f9626de5172470f51b",
  2385. "code":"BON_ELIG",
  2386. "name":"Short-term Incentive (Variable Bonus) Eligibility Y/N",
  2387. "displayLabel":"Short-term Incentive (Variable Bonus) Eligibility Y/N",
  2388. "questionType":"text",
  2389. "dataType":"string",
  2390. "hidden":false,
  2391. "updateDate":"2017-10-24T12:42:09.308Z",
  2392. "type":"question",
  2393. "tags":[
  2394.  
  2395. ],
  2396. "validators":[
  2397.  
  2398. ],
  2399. "industries":[
  2400.  
  2401. ],
  2402. "countries":[
  2403.  
  2404. ],
  2405. "__v":0
  2406. },
  2407. {
  2408. "_id":"59ef34f9626de5172470f51c",
  2409. "code":"BONUS_TPER",
  2410. "name":"Short-term Incentive (Target) as Percentage of Base",
  2411. "displayLabel":"Short-term Incentive (Target) as Percentage of Base",
  2412. "questionType":"integer",
  2413. "dataType":"int",
  2414. "hidden":false,
  2415. "updateDate":"2017-10-24T12:42:09.311Z",
  2416. "type":"question",
  2417. "tags":[
  2418.  
  2419. ],
  2420. "validators":[
  2421.  
  2422. ],
  2423. "industries":[
  2424.  
  2425. ],
  2426. "countries":[
  2427.  
  2428. ],
  2429. "__v":0
  2430. },
  2431. {
  2432. "_id":"59ef34f9626de5172470f51d",
  2433. "code":"MAXBON_TPER",
  2434. "name":"Short-term Incentive (Maximum) as Percentage of Base",
  2435. "displayLabel":"Short-term Incentive (Maximum) as Percentage of Base",
  2436. "questionType":"integer",
  2437. "dataType":"double",
  2438. "hidden":false,
  2439. "updateDate":"2017-10-24T12:42:09.314Z",
  2440. "type":"question",
  2441. "tags":[
  2442.  
  2443. ],
  2444. "validators":[
  2445.  
  2446. ],
  2447. "industries":[
  2448.  
  2449. ],
  2450. "countries":[
  2451.  
  2452. ],
  2453. "__v":0
  2454. },
  2455. {
  2456. "_id":"59ef34f9626de5172470f51e",
  2457. "code":"BONUS_ACT",
  2458. "name":"Short Term Incentive over 2016 (Actual Excluding Mandatory Deferral)",
  2459. "displayLabel":"Short Term Incentive over 2016 (Actual Excluding Mandatory Deferral)",
  2460. "questionType":"integer",
  2461. "dataType":"int",
  2462. "hidden":false,
  2463. "updateDate":"2017-10-24T12:42:09.317Z",
  2464. "type":"question",
  2465. "tags":[
  2466.  
  2467. ],
  2468. "validators":[
  2469.  
  2470. ],
  2471. "industries":[
  2472.  
  2473. ],
  2474. "countries":[
  2475.  
  2476. ],
  2477. "__v":0
  2478. },
  2479. {
  2480. "_id":"59ef34f9626de5172470f51f",
  2481. "code":"COMM_ELIG",
  2482. "name":"Sales Incentive (incl. Commissions) Eligibility",
  2483. "displayLabel":"Sales Incentive (incl. Commissions) Eligibility",
  2484. "questionType":"text",
  2485. "dataType":"string",
  2486. "hidden":false,
  2487. "updateDate":"2017-10-24T12:42:09.319Z",
  2488. "type":"question",
  2489. "tags":[
  2490.  
  2491. ],
  2492. "validators":[
  2493.  
  2494. ],
  2495. "industries":[
  2496.  
  2497. ],
  2498. "countries":[
  2499.  
  2500. ],
  2501. "__v":0
  2502. },
  2503. {
  2504. "_id":"59ef34f9626de5172470f520",
  2505. "code":"COMM_TPER",
  2506. "name":"Sales Incentive (Target) as Percentage of Base",
  2507. "displayLabel":"Sales Incentive (Target) as Percentage of Base",
  2508. "questionType":"integer",
  2509. "dataType":"int",
  2510. "hidden":false,
  2511. "updateDate":"2017-10-24T12:42:09.322Z",
  2512. "type":"question",
  2513. "tags":[
  2514.  
  2515. ],
  2516. "validators":[
  2517.  
  2518. ],
  2519. "industries":[
  2520.  
  2521. ],
  2522. "countries":[
  2523.  
  2524. ],
  2525. "__v":0
  2526. },
  2527. {
  2528. "_id":"59ef34f9626de5172470f521",
  2529. "code":"COMM_ACT",
  2530. "name":"Sales Incentive (Actual)",
  2531. "displayLabel":"Sales Incentive (Actual)",
  2532. "questionType":"integer",
  2533. "dataType":"int",
  2534. "hidden":false,
  2535. "updateDate":"2017-10-24T12:42:09.324Z",
  2536. "type":"question",
  2537. "tags":[
  2538.  
  2539. ],
  2540. "validators":[
  2541.  
  2542. ],
  2543. "industries":[
  2544.  
  2545. ],
  2546. "countries":[
  2547.  
  2548. ],
  2549. "__v":0
  2550. },
  2551. {
  2552. "_id":"59ef34f9626de5172470f522",
  2553. "code":"OTH_BONUS",
  2554. "name":"Other Short Term Incentive over 2016 ",
  2555. "displayLabel":"Other Short Term Incentive over 2016 ",
  2556. "questionType":"integer",
  2557. "dataType":"int",
  2558. "hidden":false,
  2559. "updateDate":"2017-10-24T12:42:09.327Z",
  2560. "type":"question",
  2561. "tags":[
  2562.  
  2563. ],
  2564. "validators":[
  2565.  
  2566. ],
  2567. "industries":[
  2568.  
  2569. ],
  2570. "countries":[
  2571.  
  2572. ],
  2573. "__v":0
  2574. },
  2575. {
  2576. "_id":"59ef34f9626de5172470f523",
  2577. "code":"LTI_ELIG",
  2578. "name":"Long-term Incentive Eligibility",
  2579. "displayLabel":"Long-term Incentive Eligibility",
  2580. "questionType":"text",
  2581. "dataType":"string",
  2582. "hidden":false,
  2583. "updateDate":"2017-10-24T12:42:09.329Z",
  2584. "type":"question",
  2585. "tags":[
  2586.  
  2587. ],
  2588. "validators":[
  2589.  
  2590. ],
  2591. "industries":[
  2592.  
  2593. ],
  2594. "countries":[
  2595.  
  2596. ],
  2597. "__v":0
  2598. },
  2599. {
  2600. "_id":"59ef34f9626de5172470f524",
  2601. "code":"LTINAME_1",
  2602. "name":"LTI Plan Award #1 Organisation LTI Plan Identifier",
  2603. "displayLabel":"LTI Plan Award #1 Organisation LTI Plan Identifier",
  2604. "questionType":"text",
  2605. "dataType":"string",
  2606. "hidden":false,
  2607. "updateDate":"2017-10-24T12:42:09.333Z",
  2608. "type":"question",
  2609. "tags":[
  2610.  
  2611. ],
  2612. "validators":[
  2613.  
  2614. ],
  2615. "industries":[
  2616.  
  2617. ],
  2618. "countries":[
  2619.  
  2620. ],
  2621. "__v":0
  2622. },
  2623. {
  2624. "_id":"59ef34f9626de5172470f525",
  2625. "code":"LTISHARECASH_1",
  2626. "name":"Number of granted Options/ Shares/ Performance Units or value of granted Cash Award",
  2627. "displayLabel":"Number of granted Options/ Shares/ Performance Units or value of granted Cash Award",
  2628. "questionType":"text",
  2629. "dataType":"string",
  2630. "hidden":false,
  2631. "updateDate":"2017-10-24T12:42:09.336Z",
  2632. "type":"question",
  2633. "tags":[
  2634.  
  2635. ],
  2636. "validators":[
  2637.  
  2638. ],
  2639. "industries":[
  2640.  
  2641. ],
  2642. "countries":[
  2643.  
  2644. ],
  2645. "__v":0
  2646. },
  2647. {
  2648. "_id":"59ef34f9626de5172470f526",
  2649. "code":"LTINAME_2",
  2650. "name":"LTI Plan Award #2 Organisation LTI Plan Identifier",
  2651. "displayLabel":"LTI Plan Award #2 Organisation LTI Plan Identifier",
  2652. "questionType":"text",
  2653. "dataType":"string",
  2654. "hidden":false,
  2655. "updateDate":"2017-10-24T12:42:09.339Z",
  2656. "type":"question",
  2657. "tags":[
  2658.  
  2659. ],
  2660. "validators":[
  2661.  
  2662. ],
  2663. "industries":[
  2664.  
  2665. ],
  2666. "countries":[
  2667.  
  2668. ],
  2669. "__v":0
  2670. },
  2671. {
  2672. "_id":"59ef34f9626de5172470f527",
  2673. "code":"LTISHARECASH_2",
  2674. "name":"Number of granted Options/ Shares/ Performance Units or value of granted Cash Award",
  2675. "displayLabel":"Number of granted Options/ Shares/ Performance Units or value of granted Cash Award",
  2676. "questionType":"text",
  2677. "dataType":"string",
  2678. "hidden":false,
  2679. "updateDate":"2017-10-24T12:42:09.342Z",
  2680. "type":"question",
  2681. "tags":[
  2682.  
  2683. ],
  2684. "validators":[
  2685.  
  2686. ],
  2687. "industries":[
  2688.  
  2689. ],
  2690. "countries":[
  2691.  
  2692. ],
  2693. "__v":0
  2694. },
  2695. {
  2696. "_id":"59ef34f9626de5172470f528",
  2697. "code":"LTINAME_3",
  2698. "name":"LTI Plan Award #3 Organisation LTI Plan Identifier",
  2699. "displayLabel":"LTI Plan Award #3 Organisation LTI Plan Identifier",
  2700. "questionType":"text",
  2701. "dataType":"string",
  2702. "hidden":false,
  2703. "updateDate":"2017-10-24T12:42:09.345Z",
  2704. "type":"question",
  2705. "tags":[
  2706.  
  2707. ],
  2708. "validators":[
  2709.  
  2710. ],
  2711. "industries":[
  2712.  
  2713. ],
  2714. "countries":[
  2715.  
  2716. ],
  2717. "__v":0
  2718. },
  2719. {
  2720. "_id":"59ef34f9626de5172470f529",
  2721. "code":"LTISHARECASH_3",
  2722. "name":"Number of granted Options/ Shares/ Performance Units or value of granted Cash Award",
  2723. "displayLabel":"Number of granted Options/ Shares/ Performance Units or value of granted Cash Award",
  2724. "questionType":"text",
  2725. "dataType":"string",
  2726. "hidden":false,
  2727. "updateDate":"2017-10-24T12:42:09.348Z",
  2728. "type":"question",
  2729. "tags":[
  2730.  
  2731. ],
  2732. "validators":[
  2733.  
  2734. ],
  2735. "industries":[
  2736.  
  2737. ],
  2738. "countries":[
  2739.  
  2740. ],
  2741. "__v":0
  2742. },
  2743. {
  2744. "_id":"59ef34f9626de5172470f52a",
  2745. "code":"CAR_BEN_TYPE",
  2746. "name":"Type of Company Car Benefit",
  2747. "displayLabel":" Type of Company Car Benefit",
  2748. "questionType":"text",
  2749. "dataType":"string",
  2750. "hidden":false,
  2751. "updateDate":"2017-10-24T12:42:09.351Z",
  2752. "type":"question",
  2753. "tags":[
  2754.  
  2755. ],
  2756. "validators":[
  2757.  
  2758. ],
  2759. "industries":[
  2760.  
  2761. ],
  2762. "countries":[
  2763.  
  2764. ],
  2765. "__v":0
  2766. },
  2767. {
  2768. "_id":"59ef34f9626de5172470f52b",
  2769. "code":"CAR_ALLOW",
  2770. "name":"ANNUAL Allowance in Lieu of a Company Car",
  2771. "displayLabel":" ANNUAL Allowance in Lieu of a Company Car",
  2772. "questionType":"integer",
  2773. "dataType":"int",
  2774. "hidden":false,
  2775. "updateDate":"2017-10-24T12:42:09.354Z",
  2776. "type":"question",
  2777. "tags":[
  2778.  
  2779. ],
  2780. "validators":[
  2781.  
  2782. ],
  2783. "industries":[
  2784.  
  2785. ],
  2786. "countries":[
  2787.  
  2788. ],
  2789. "__v":0
  2790. },
  2791. {
  2792. "_id":"59ef34f9626de5172470f52c",
  2793. "code":"CAR_LISTPRICE",
  2794. "name":"List Price (incl. VAT)",
  2795. "displayLabel":" List Price (incl. VAT)",
  2796. "questionType":"integer",
  2797. "dataType":"int",
  2798. "hidden":false,
  2799. "updateDate":"2017-10-24T12:42:09.357Z",
  2800. "type":"question",
  2801. "tags":[
  2802.  
  2803. ],
  2804. "validators":[
  2805.  
  2806. ],
  2807. "industries":[
  2808.  
  2809. ],
  2810. "countries":[
  2811.  
  2812. ],
  2813. "__v":0
  2814. },
  2815. {
  2816. "_id":"59ef34f9626de5172470f52d",
  2817. "code":"CAR_MLEASE",
  2818. "name":"Monthly Lease Cost (incl. VAT)",
  2819. "displayLabel":" Monthly Lease Cost (incl. VAT)",
  2820. "questionType":"integer",
  2821. "dataType":"int",
  2822. "hidden":false,
  2823. "updateDate":"2017-10-24T12:42:09.360Z",
  2824. "type":"question",
  2825. "tags":[
  2826.  
  2827. ],
  2828. "validators":[
  2829.  
  2830. ],
  2831. "industries":[
  2832.  
  2833. ],
  2834. "countries":[
  2835.  
  2836. ],
  2837. "__v":0
  2838. },
  2839. {
  2840. "_id":"59ef34f9626de5172470f52e",
  2841. "code":"CAR_REPL",
  2842. "name":"Replacement Term (in Years)",
  2843. "displayLabel":"Replacement Term (in Years)",
  2844. "questionType":"integer",
  2845. "dataType":"int",
  2846. "hidden":false,
  2847. "updateDate":"2017-10-24T12:42:09.362Z",
  2848. "type":"question",
  2849. "tags":[
  2850.  
  2851. ],
  2852. "validators":[
  2853.  
  2854. ],
  2855. "industries":[
  2856.  
  2857. ],
  2858. "countries":[
  2859.  
  2860. ],
  2861. "__v":0
  2862. },
  2863. {
  2864. "_id":"59ef34f9626de5172470f52f",
  2865. "code":"CAR_FUEL",
  2866. "name":"Fuel for private use paid by organisation (%)",
  2867. "displayLabel":" Fuel for private use paid by organisation (%)",
  2868. "questionType":"checkboxes",
  2869. "dataType":"string",
  2870. "options":{
  2871. "items":[
  2872. {
  2873. "value":"option1",
  2874. "displayName":"Option1"
  2875. },
  2876. {
  2877. "value":"option2",
  2878. "displayName":"Option2"
  2879. },
  2880. {
  2881. "value":"option3",
  2882. "displayName":"Option3"
  2883. },
  2884. {
  2885. "value":"option4",
  2886. "displayName":"Option4"
  2887. }
  2888. ],
  2889. "questionsAnswers":[
  2890.  
  2891. ]
  2892. },
  2893. "hidden":false,
  2894. "updateDate":"2017-10-24T12:42:09.365Z",
  2895. "type":"question",
  2896. "tags":[
  2897.  
  2898. ],
  2899. "validators":[
  2900. {
  2901. "errorType":"error",
  2902. "validationType":"expression",
  2903. "expression":"decode(length({this.CAR_FUEL}) < 2, 'true', 'false')",
  2904. "errorGroup":"job_info",
  2905. "message":"CAR_FUEL please choose two options at least",
  2906. "_id":"59ef3521626de51724712e28",
  2907. "category":"input_data",
  2908. "dependentColumns":[
  2909.  
  2910. ]
  2911. }
  2912. ],
  2913. "industries":[
  2914.  
  2915. ],
  2916. "countries":[
  2917.  
  2918. ],
  2919. "__v":0
  2920. }
  2921. ]
  2922. }
  2923. ]
  2924. }
  2925. }
  2926. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!