HR_DRPT_TEST(SQL Table) |
Index Back |
|---|---|
Direct Reports ResultsUsed by the HR Direct Reports application class test component to display the results of the various app class methods. This record definition is used to display the contents of the DirectReports rowset. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 3 | EMPL_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Payroll Status
A=Active D=Deceased L=Leave of Absence P=Leave With Pay Q=Retired With Pay R=Retired S=Suspended T=Terminated U=Terminated With Pay V=Terminated Pension Pay Out W=Short Work Break X=Retired-Pension Administration |
| 4 | SETID_DEPT | Character(5) | VARCHAR2(5) NOT NULL | Department Set ID |
| 5 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 6 | SETID_LOCATION | Character(5) | VARCHAR2(5) NOT NULL | Location Set ID |
| 7 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Location Code |
| 8 | SETID_JOBCODE | Character(5) | VARCHAR2(5) NOT NULL | Job Code Set ID |
| 9 | JOBCODE | Character(6) | VARCHAR2(6) NOT NULL | Job Code |
| 10 | POSITION_NBR | Character(8) | VARCHAR2(8) NOT NULL | Position Number |
| 11 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 12 | NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Display Name - name formatted for Display based on the Country |
| 13 | LAST_NAME_SRCH | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 14 | NAME_AC | Character(50) | VARCHAR2(50) NOT NULL | Alternate Character Name |
| 15 | LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 16 | FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | First Name |