SETIDPrompt Table: SETID_TBL
SETCNTRLVALUETREE_NAMEPrompt Table: PSTREEDEFN
TREE_EFFDTTREE_NODEPrompt Table: HRCD_JBTRPRM_VW
EMPLIDEMPL_RCDHRCD_JOBTR_EXCP(SQL Table) |
Index Back |
|---|---|
Company Directory ExceptionsThis table stores the list of active employee Jobs where nodes were not automatically created for the Company Directory Tree by the batch process. Reasons these Jobs were not added to the Tree could be that the user chose on the run control page to not include multiple Jobs in the Tree or the Access Type selected by the user did not apply to particular Jobs. The column TREE_NODE contains a unique serial number. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SETID_TBL |
| 2 | SETCNTRLVALUE |
Character(20) | VARCHAR2(20) NOT NULL | Tree Definition User Key Value |
| 3 | TREE_NAME |
Character(18) | VARCHAR2(18) NOT NULL |
Tree Name
Prompt Table: PSTREEDEFN |
| 4 | TREE_EFFDT |
Date(10) | DATE | Effective date of the Tree |
| 5 | TREE_NODE |
Character(20) | VARCHAR2(20) NOT NULL |
Node name
Prompt Table: HRCD_JBTRPRM_VW |
| 6 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 7 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 8 | SEQUENCENO | Number(10,0) | DECIMAL(10) NOT NULL | Sequence Number |
| 9 | 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. |
| 10 | 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. |
| 11 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |