ASSGN_SUM_VW(SQL View) |
Index Back |
---|---|
EE Assignment-Home/Host DataASGN_HOME_HOST is one of a group of records used to record information about an employee's job assignments away from home base. Use ASGN_HOME_HOST to set up a 'home' parent record and a 'host' parent record for an employee's international assignment data. Subordinate detail records contain the details pertaining to the assignment. This data is part of the International Assignment application. You can create multiple ASGN_HOME_HOST records for an employee. |
SELECT A.EMPLID, A.BEGIN_DT, A.HOME_HOST, A.HOME_HOST_EMPL_RCD, B.END_DT, B.ASSGN_TYPE FROM PS_ASGN_HOME_HOST A, PS_ASSIGNMENT B WHERE A.HOME_HOST <> '0' AND B.EMPLID = A.EMPLID AND B.BEGIN_DT = A.BEGIN_DT |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
2 | BEGIN_DT | Date(10) | DATE | Begin Date |
3 | HOME_HOST | Character(1) | VARCHAR2(1) NOT NULL |
Home or Host
0=Home 1=Host 1 2=Host 2 |
4 | HOME_HOST_EMPL_RCD | Character(3) | VARCHAR2(3) NOT NULL | Home/Host Employment Record # |
5 | END_DT | Date(10) | DATE | end date |
6 | ASSGN_TYPE | Character(3) | VARCHAR2(3) NOT NULL | Assignment Type |