TREE_NODEPrompt Table: HRCD_JBTRPRM_VW
EMPLIDEMPL_RCDHRCD_JOB_TREE(SQL Table) |
Index Back |
|---|---|
Company Directory NodesThis table stores the list of available employee Job nodes for the Company Directory Tree. This table will contain all active Jobs as of a given date. The Jobs in this table may or may not exist in the corresponding Tree, but a row must exist in this table before a Job can be added to the Tree. The column TREE_NODE contains a unique serial number. This table acts as a foreign key table to get emplid for a tree node. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TREE_NODE |
Character(20) | VARCHAR2(20) NOT NULL |
Node name
Prompt Table: HRCD_JBTRPRM_VW |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 4 | SEQUENCENO | Number(10,0) | DECIMAL(10) NOT NULL | Sequence Number |
| 5 | LASTUPDOPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 6 | 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. |
| 7 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |