HR_SRCH_DR_AET(SQL Table) |
Index Back |
|---|---|
SES: Direct Reports State RecPrimary state record in HR_SRCH_DR AE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 4 | SUPERVISOR_ID | Character(11) | VARCHAR2(11) NOT NULL | Supervisor ID |
| 5 | PNLGRPNAME | Character(18) | VARCHAR2(18) NOT NULL | Component Name |
| 6 | ACCESS_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Access Type
1=By Dept Security Tree 2=By Supervisor ID 3=By Department Manager ID 4=By Reports To Position 5=By Part Posn Mgmt Supervisor 6=By Part Posn Mgmt Dept Mgr ID 7=By Group ID |
| 7 | AE_APPLID | Character(12) | VARCHAR2(12) NOT NULL | Program Name (see PSAEAPPLDEFN). |
| 8 | AE_SECTION | Character(8) | VARCHAR2(8) NOT NULL | Section |
| 9 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 10 | RECNAME_2 | Character(15) | VARCHAR2(15) NOT NULL | Record 2 Name |
| 11 | HR_DR_LEVEL | Number(3,0) | SMALLINT NOT NULL | Number denoting how many levels down the organizational chart the employee is from the supervisor. Direct reports are always level 1. |
| 12 | HR_SRCH_CTRL_ID | Number(10,0) | DECIMAL(10) NOT NULL | EIP Control Id |
| 13 | PROCESSED | Character(1) | VARCHAR2(1) NOT NULL |
Processed?
I=In Process N=Not Processed Y=Processed |
| 14 | PROCESS_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Process Type
I=Referential Integrity R=Rule (User Exit) V=Validation |
| 15 | SQLTEXT | Long Character(14000) | CLOB | SQL Statement Text |
| 16 | HR_SRCH_RECNAME | Character(15) | VARCHAR2(15) NOT NULL | SES: mapped to Search table names in HR_SRCH_DR AE |
| 17 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 18 | ROWSECCLASS | Character(30) | VARCHAR2(30) NOT NULL | The class used to determine row level security |
| 19 | EMPLID2 | Character(11) | VARCHAR2(11) NOT NULL | Field is referenced in state record used by Cobra Upgrade. |
| 20 | ROWSECCLASS_OLD | Character(30) | VARCHAR2(30) NOT NULL | Old Row Security Permission List |
| 21 | GB_GROUP_ID | Character(15) | VARCHAR2(15) NOT NULL | Group Build ID. |
| 22 | DATE1 | Date(10) | DATE | Date 1 |
| 23 | REPORTS_TO | Character(8) | VARCHAR2(8) NOT NULL | Reports To Position Number |
| 24 | LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 25 | STARTDATETIME | DateTime(26) | TIMESTAMP | Start Datetime |