ASSIGNME

EFFECTIVEFFECTIVBUSINESSRECRUITEGRADE_IDPOSITIONJOB_ID ASSIGNME
PAYROLL_LOCATIONPERSON_R
SUPERVISSPECIAL_PERSON_IRECRUITMSOURCE_O
ORGANIZA
PEOPLE_GSOFT_COD
VACANCY_PAY_BASIASSIGNM ASSIGNME
PRIMARY_APPLICATASSIGNM CHANGE_COMMENTDATE_PRODEFAULT_EMPLOYMFREQUENINTERNALMANAGERNORMAL_PERF_REVPERF_REVPERIOD_OPROBATIOPROBATIOSAL_REVI SAL_REVI SET_OF_BSOURCE_TIME_NORTIME_NORBARGAINILABOUR_UHOURLY_SCONTRACT
COLLECTICAGR_ID_CAGR_GRA
ESTABLISREQUEST_
PROGRAM_
PROGRAMPROGRAMASS_ATTRASS_ATTRASS_ATTRASS_ATTRASS_ATTRASS_ATTRASS_ATTRASS_ATTRASS_ATTRASS_ATTRASS_ATTRASS_ATTRASS_ATTRASS_ATTRASS_ATTRASS_ATTRASS_ATTRASS_ATTRASS_ATTRASS_ATTRASS_ATTRASS_ATTRASS_ATTRASS_ATTRASS_ATTRASS_ATTRASS_ATTRASS_ATTRASS_ATTRASS_ATTRASS_ATTRLAST_UPDLAST_UPDLAST_UPDCREATED_CREATIONTITLE OBJECT_VNOTICE_PNOTICE_PEMPLOYEWORK_ATJOB_POS POSTING_PERIOD_OVENDOR_IVENDOR_VENDOR_ASSIGNM PROJECT_APPLICANVENDOR_S
PO_HEADE
PO_LINE_IPROJECTE
GRADE_LASUPERVISOR_ASSIGNMENT_ID
309172 01-JAN-20 14-JAN-20 84 18384 1 128 292 564645 464292 11302 455481 425 69 1E Y 110129 PR_PROM 184558 FT_GBL W 40 893829 3 17:30 08:30 S 84 mapl 10005709 JP02179 Senior Environmental S520625 141048 682686 166021 614228 06-FEB-20 288088 -1 42939 07-JUL-14 113 IN_PE N
309172 29-JAN-22 30-MAR-22 84 18384 1 128 292 73538 464292 11302 455481 425 69 1E Y 110129 RECL 184558 FT_GBL W 40 893829 3 17:30 08:30 S 84 mapl 10005709 JP02179 Senior Environmental S520625 141048 736936 764259 766646 31-MAR-22 22439 -1 42939 07-JUL-14 138 IN_PE N
309172 31-MAR-2230-SEP-22 84 18384 1 128 292 73538 464292 11302 455481 425 69 1E Y 110129 SUPR 184558 FT_GBL W 40 893829 3 17:30 08:30 S 84 mapl 10005709 JP02179 Senior Environmental S474938 141048 736936 764259 766646 30-SEP-22 13496 -1 42939 07-JUL-14 140 IN_PE N
309172 10-AUG-2023-DEC-20 84 18384 1 128 292 73538 464292 11302 455481 425 69 1E Y 110129 DTA 184558 FT_GBL W 40 893829 3 17:30 08:30 S 84 mapl 10005709 JP02179 Senior Environmental S520625 141048 739208 740633 740632 24-DEC-20 22439 -1 42939 07-JUL-14 125 IN_PE N
309172 24-MAY-2115-JUN-21 84 18384 1 128 292 73538 464292 11302 455481 425 69 1E Y 110129 DTA 184558 FT_GBL W 40 893829 3 17:30 08:30 S 84 mapl 10005709 JP02179 Senior Environmental S520625 141048 739208 740633 740632 16-JUN-21 22439 -1 42939 07-JUL-14 131 IN_PE N
309172 16-JUN-21 28-JAN-22 84 18384 1 128 292 73538 464292 11302 455481 425 69 1E Y 110129 DTA 184558 FT_GBL W 40 893829 3 17:30 08:30 S 84 mapl 10005709 JP02179 Senior Environmental S520625 141048 739208 740633 740632 29-JAN-22 13496 -1 42939 07-JUL-14 134 IN_PE N
309172 20-APR-2418-OCT-24 84 18383 2 128 292 73538 464292 11302 455481 425 69 1E Y 110129 DTA 184558 FT_GBL W 40 893829 3 17:30 08:30 S 84 mapl 10005709 JP02180 Environmental Scientis474938 141048 736936 800624 787723 21-OCT-24 53148 -1 42939 07-JUL-14 163 IN_PE N
309172 01-OCT-2225-AUG-23 84 18383 1 128 292 73538 464292 11302 455481 425 69 1E Y 110129 DTA 184558 FT_GBL W 40 893829 3 17:30 08:30 S 84 mapl 10005709 JP02180 Environmental Scientis474938 141048 736936 764259 766646 28-AUG-23 53148 -1 42939 07-JUL-14 147 IN_PE N
309172 02-MAR-2424-MAR-24 84 18383 1 128 292 73538 464292 11302 455481 425 69 1E Y 110129 RT_LOA 184558 FT_GBL W 40 893829 3 17:30 08:30 S 84 mapl 10005709 JP02180 Environmental Scientis474938 141048 736936 764259 787723 25-FEB-24 22439 -1 42939 07-JUL-14 157 IN_PE N
309172 25-MAR-2419-APR-24 84 18383 2 128 292 73538 464292 11302 455481 425 69 1E Y 110129 DTA 184558 FT_GBL W 40 893829 3 17:30 08:30 S 84 mapl 10005709 JP02180 Environmental Scientis474938 141048 736936 764259 787723 22-APR-24 53148 -1 42939 07-JUL-14 159 IN_PE N
309172 26-AUG-2310-DEC-23 84 18383 1 128 292 73538 464292 11302 455481 425 69 1E Y 110129 DTA 184558 FT_GBL W 40 893829 3 17:30 08:30 S 84 mapl 10005709 JP02180 Environmental Scientis474938 141048 736936 764259 787723 11-NOV-23 22439 -1 42939 07-JUL-14 153 IN_PE N
309172 11-DEC-2301-MAR-24 84 18383 2 128 292 73538 464292 11302 455481 425 69 1E Y 110129 DTA 184558 FT_GBL W 40 893829 3 17:30 08:30 S 84 mapl 10005709 JP02180 Environmental Scientis474938 141048 736936 764259 787723 18-FEB-24 22439 -1 42939 07-JUL-14 155 IN_PE N
309172 12-NOV-1530-APR-16 84 18386 1 128 292 520625 464292 11302 1545 425 69 1E Y 110129 NH 184558 FT_GBL W 37.5 893829 3 17:30 08:30 S 84 mapl Graduate Environmental73538 141048 30335 71617 57960 20-APR-16 170860 -1 42939 07-JUL-14 8 IN_PE N
309172 07-JUL-14 27-JUL-14 84 18386 1 128 292 129531 464292 11302 1545 425 69 1E Y 110129 NH 184558 FT_GBL W 37.5 893829 3 17:30 08:30 S 84 mapl Graduate Environmental156800 135985 30335 71617 57960 28-JUL-14 170860 9E+07 42939 07-JUL-14 4 IN_PE N
309172 28-JUL-14 03-MAY-15 84 18386 1 128 292 73538 464292 11302 1545 425 69 1E Y 110129 NH 184558 FT_GBL W 37.5 893829 3 17:30 08:30 S 84 mapl Graduate Environmental351581 129531 30335 71617 57960 03-MAY-15 195595 1E+08 42939 07-JUL-14 6 IN_PE N
309172 04-MAY-1511-NOV-15 84 18386 1 128 292 73538 464292 11302 1545 425 69 1E Y 110129 NH 184558 FT_GBL W 37.5 893829 3 17:30 08:30 S 84 mapl Graduate Environmental136057 141048 30335 71617 57960 11-NOV-15 210350 -1 42939 07-JUL-14 7 IN_PE N
309172 05-MAY-1814-OCT-18 84 18385 1 128 292 631664 464292 75382 94441 425 69 1E Y 110129 ASSGN 917131 FT_GBL W 40 893829 3 17:30 08:30 S 84 mapl PH0131 Environmental Scientis520625 141048 682686 540235 614228 16-OCT-18 -1 -1 42939 07-JUL-14 38 IN_PE N
309172 01-MAY-1606-MAY-16 84 18386 1 128 292 520625 464292 11302 1545 425 69 1E Y 110129 NH 184558 FT_GBL W 40 893829 3 17:30 08:30 S 84 mapl Graduate Environmental73538 141048 30335 71617 57960 04-MAY-16 170860 -1 42939 07-JUL-14 11 IN_PE N
309172 30-NOV-1631-DEC-16 84 18386 1 128 292 520625 464292 11302 1545 425 69 1E Y 110129 NH 184558 FT_GBL W 40 893829 3 17:30 08:30 S 84 mapl Environmental Scientis308820 141048 30335 446536 530290 20-DEC-16 239970 -1 42939 07-JUL-14 17 IN_PE N
309172 07-MAY-1619-JUN-16 84 18386 1 128 292 520625 464292 11302 1545 425 69 1E Y 110129 NH 184558 FT_GBL W 40 893829 3 17:30 08:30 S 84 mapl Graduate Environmental73538 141048 30335 446536 530290 20-JUN-16 210350 -1 42939 07-JUL-14 15 IN_PE N
309172 19-OCT-2406-DEC-24 84 18383 2 128 292 73538 464292 11302 455481 425 69 1E Y 110129 DTA 184558 FT_GBL W 40 893829 3 17:30 08:30 S 84 mapl 10005709 JP02180 Environmental Scientis474938 141048 736936 823506 823126 09-DEC-24 53148 -1 42939 07-JUL-14 167 IN_PE N
309172 18-JAN-25 19-JAN-25 84 18383 1 128 292 512157 464292 11302 455481 425 69 1E Y 110129 RT_LOA 184558 FT_GBL W 40 893829 3 17:30 08:30 S 84 mapl 10005709 JP02180 Environmental Scientis474938 141048 736936 824506 823126 02-FEB-25 22439 -1 42939 07-JUL-14 180 IN_PE N
309172 03-MAR-2516-MAR-25 84 18383 1 128 292 512157 464292 11302 455481 425 69 1E Y 110129 DTA 184558 PT_GBL W 32 893829 3 17:30 08:30 S 84 mapl 10005709 JP02180 Environmental Scientis474938 141048 736936 824506 823126 12-MAR-25 344237 -1 42939 07-JUL-14 191 IN_PE N
309172 17-MAR-2519-MAR-25 84 18383 1 128 292 512157 464292 11302 455481 425 69 1E Y 110129 DTA 184558 PT_GBL W 32 893829 3 17:30 08:30 S 84 mapl 10005709 JP02180 Environmental Scientis474938 141048 736936 824506 823126 20-MAR-25 22439 -1 42939 07-JUL-14 198 IN_PE N
309172 20-MAR-2521-MAR-25 84 18383 1 128 292 474938 464292 11302 455481 425 69 1E Y 110129 SUPR 184558 PT_GBL W 32 893829 3 17:30 08:30 S 84 mapl 10005709 JP02180 Environmental Scientis73538 141048 736936 824506 823126 25-MAR-25 53148 -1 42939 07-JUL-14 200 IN_PE N
309172 22-MAR-2530-JUN-25 84 18383 1 128 292 474938 464292 11302 455481 425 69 1E Y 110129 SUPR 184558 PT_GBL W 32 893829 3 17:30 08:30 S 84 mapl 10005709 JP02180 Environmental Scientis73538 141048 736936 824506 807627 07-JUL-25 22439 -1 42939 07-JUL-14 204 IN_PE N
309172 01-JUL-25 31-JUL-25 84 18383 1 128 292 474938 464292 11302 455481 425 69 1E Y 110129 DTA 184558 FT_GBL W 40 893829 3 17:30 08:30 S 84 mapl 10005709 JP02180 Environmental Scientis73538 141048 736936 824506 807627 28-JUL-25 312309 4E+08 42939 07-JUL-14 214 IN_PE N
309172 07-DEC-2431-DEC-24 84 18383 2 128 292 73538 464292 11302 455481 425 69 1E Y 110129 DTA 184558 FT_GBL W 40 893829 3 17:30 08:30 S 84 mapl 10005709 JP02180 Environmental Scientis474938 141048 736936 824506 823126 17-DEC-24 22439 -1 42939 07-JUL-14 171 IN_PE N
309172 01-JAN-25 17-JAN-25 84 18383 2 128 292 512157 464292 11302 455481 425 69 1E Y 110129 DTA 184558 FT_GBL W 40 893829 3 17:30 08:30 S 84 mapl 10005709 JP02180 Environmental Scientis474938 141048 736936 824506 823126 13-JAN-25 22439 -1 42939 07-JUL-14 178 IN_PE N
309172 20-JAN-25 02-MAR-25 84 18383 1 128 292 512157 464292 11302 455481 425 69 1E Y 110129 DTA 184558 PT_GBL W 24 893829 3 17:30 08:30 S 84 mapl 10005709 JP02180 Environmental Scientis474938 141048 736936 824506 823126 11-FEB-25 22439 -1 42939 07-JUL-14 184 IN_PE N
309172 01-AUG-2517-AUG-25 84 18383 1 128 292 474938 464292 11302 455481 425 69 1E Y 110129 DTA 184558 FT_GBL W 40 893829 3 17:30 08:30 S 84 mapl 10005709 JP01659 Environmental Planner 73538 736936 824506 807627 28-JUL-25 312309 4E+08 42939 07-JUL-14 210 IN_PE N
309172 18-AUG-2531-DEC-12 84 18383 2 128 292 474938 464292 11302 455481 425 69 1E Y 110129 DTA 184558 FT_GBL W 40 893829 3 17:30 08:30 S 84 mapl 10005709 JP01659 Principal Environmental73538 736936 824506 807627 06-AUG-25 22439 -1 42939 07-JUL-14 218 IN_PE N
309172 18-MAR-1818-MAR-18 84 18385 1 128 292 73538 464292 75382 94441 425 69 1E Y 110129 ASSGN 917131 FT_GBL W 40 893829 3 17:30 08:30 S 84 mapl PH0131 Environmental Scientis520625 141048 596027 540235 614228 15-MAY-18 257256 -1 42939 07-JUL-14 32 IN_PE N
309172 06-FEB-1717-MAR-18 84 18385 1 128 292 73538 464292 11302 1545 425 69 1E Y 110129 ASSGN 184558 FT_GBL W 40 893829 3 17:30 08:30 S 84 mapl PH0131 Environmental Scientis520625 141048 596027 540235 614228 19-MAR-18 268596 2E+08 42939 07-JUL-14 30 IN_PE N
309172 20-JUN-16 29-NOV-16 84 18386 1 128 292 520625 464292 11302 1545 425 69 1E Y 110129 NH 184558 FT_GBL W 40 893829 3 17:30 08:30 S 84 mapl Environmental Scientis73538 141048 30335 446536 530290 30-NOV-16 230282 -1 42939 07-JUL-14 16 IN_PE N
309172 01-JAN-17 20-JAN-17 84 18385 1 128 292 520625 464292 11302 1545 425 69 1E Y 110129 PR_PROM 184558 FT_GBL W 40 893829 3 17:30 08:30 S 84 mapl Environmental Scientis308820 141048 30335 446536 530290 24-JAN-17 13496 -1 42939 07-JUL-14 20 IN_PE N
309172 21-JAN-17 05-FEB-17 84 18385 1 128 292 520625 464292 11302 1545 425 69 1E Y 110129 ASSGN 184558 FT_GBL W 40 893829 3 17:30 08:30 S 84 mapl PH0131 Environmental Scientis308820 141048 30335 446536 530290 06-FEB-17 257256 2E+08 42939 07-JUL-14 23 IN_PE N
309172 19-MAR-1804-MAY-18 84 18385 1 128 292 394558 464292 75382 94441 425 69 1E Y 110129 ASSGN 917131 FT_GBL W 40 893829 3 17:30 08:30 S 84 mapl PH0131 Environmental Scientis520625 141048 596027 540235 614228 15-MAY-18 257256 -1 42939 07-JUL-14 32 IN_PE N
309172 15-OCT-1831-DEC-18 84 18385 1 128 292 631664 464292 75382 94441 425 69 1E Y 110129 ASSGN 917131 FT_GBL W 40 893829 3 17:30 08:30 S 84 mapl 10005709 JP02178 Environmental Scientis520625 141048 682686 166021 614228 25-DEC-18 22439 -1 42939 07-JUL-14 43 IN_PE N
309172 01-JAN-19 10-MAR-19 84 18385 1 128 292 530807 464292 75382 94441 425 69 1E Y 110129 DTA 917131 FT_GBL W 40 893829 3 17:30 08:30 S 84 mapl 10005709 JP02178 Environmental Scientis520625 141048 682686 166021 614228 21-MAR-19 22439 -1 42939 07-JUL-14 93 IN_PE N
309172 11-MAR-1931-MAY-19 84 18385 1 128 292 680158 464292 11302 94441 425 69 1E Y 110129 DTA 184558 FT_GBL W 40 893829 3 17:30 08:30 S 84 mapl 10005709 JP02178 Environmental Scientis520625 141048 682686 166021 614228 22-MAY-19 22439 -1 42939 07-JUL-14 97 IN_PE N
309172 01-JUN-19 05-OCT-19 84 18385 1 128 292 564645 464292 11302 94441 425 69 1E Y 110129 DTA 184558 FT_GBL W 40 893829 3 17:30 08:30 S 84 mapl 10005709 JP02178 Environmental Scientis520625 141048 682686 166021 614228 14-OCT-19 190352 -1 42939 07-JUL-14 101 IN_PE N
309172 15-JAN-20 31-JAN-20 84 18384 1 128 292 73538 464292 11302 455481 425 69 1E Y 110129 PR_PROM 184558 FT_GBL W 40 893829 3 17:30 08:30 S 84 mapl 10005709 JP02179 Senior Environmental S520625 141048 682686 166021 614228 06-FEB-20 288088 -1 42939 07-JUL-14 110 IN_PE N
309172 06-OCT-1931-DEC-19 84 18385 1 128 292 564645 464292 11302 455481 425 69 1E Y 110129 DTA 184558 FT_GBL W 40 893829 3 17:30 08:30 S 84 mapl 10005709 JP02178 Environmental Scientis520625 141048 682686 166021 614228 10-DEC-19 284780 3E+08 42939 07-JUL-14 104 IN_PE N
309172 01-FEB-2014-FEB-20 84 18384 1 128 292 73538 464292 11302 455481 425 69 1E Y 110129 DTA 184558 FT_GBL W 40 893829 3 17:30 08:30 S 84 mapl 10005709 JP02179 Senior Environmental S520625 141048 682686 166021 614228 19-FEB-20 124899 -1 42939 07-JUL-14 114 IN_PE N
309172 15-FEB-2009-AUG-20 84 18384 1 128 292 73538 464292 11302 455481 425 69 1E Y 110129 DTA 184558 FT_GBL W 40 893829 3 17:30 08:30 S 84 mapl 10005709 JP02179 Senior Environmental S520625 141048 511857 740633 12-AUG-20 313282 -1 42939 07-JUL-14 120 IN_PE N
309172 24-DEC-2023-MAY-21 84 18384 1 128 292 474938 464292 11302 455481 425 69 1E Y 110129 SUPR 184558 FT_GBL W 40 893829 3 17:30 08:30 S 84 mapl 10005709 JP02179 Senior Environmental S520625 141048 739208 740633 740632 26-MAY-21 22439 -1 42939 07-JUL-14 127 IN_PE N
select * from apps.per_all_assignments_f where person_id=464292