HR_JOBTREE_META(SQL Table) |
Index Back |
|---|---|
Job Tree Builder Meta DataUsed as a prompt view for the Job Tree Builder run control page. Contents of this table provide defaults for the run control that are consumed later by the application engine and app class. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  TREE_STRCT_ID |
Character(18) | VARCHAR2(18) NOT NULL |
Tree Structure Name (see PSTREESTRCT).
Prompt Table: PSTREESTRCT |
| 2 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SETID_TBL |
| 3 | SETCNTRLVALUE | Character(20) | VARCHAR2(20) NOT NULL | Tree Definition User Key Value |
| 4 | TREE_NAME | Character(18) | VARCHAR2(18) NOT NULL | Tree Name |
| 5 | TREE_CATEGORY | Character(18) | VARCHAR2(18) NOT NULL |
Category name for the Tree
Default Value: DEFAULT Prompt Table: PSTREECATGVW |
| 6 | HR_RECNAME_TRGT | Character(15) | VARCHAR2(15) NOT NULL |
Target Record Name
Prompt Table: HR_RECDEFN_VW1 |
| 7 | AE_APPLID | Character(12) | VARCHAR2(12) NOT NULL |
Program Name (see PSAEAPPLDEFN).
Prompt Table: HR_AE_LIB_VW |
| 8 | AE_SECTION | Character(8) | VARCHAR2(8) NOT NULL |
Section
Prompt Table: HR_AE_LIBSEC_VW |
| 9 | APPCLASSID | Character(30) | VARCHAR2(30) NOT NULL | Application Class ID |
| 10 | PACKAGEROOT | Character(30) | VARCHAR2(30) NOT NULL | Root Package ID |
| 11 | QUALIFYPATH | Character(127) | VARCHAR2(127) NOT NULL | Qualified Package/Class Path |
| 12 | EDITTABLE | Character(15) | VARCHAR2(15) NOT NULL | Edit Table |
| 13 | HR_JTR_KEY_FLDNAME | Character(18) | VARCHAR2(18) NOT NULL |
Job Tree Key Field Name
Default Value: TREE_NODE |
| 14 | HR_JTR_SEQ_FLDNAME | Character(18) | VARCHAR2(18) NOT NULL |
Sequence Field Name
Default Value: SEQUENCENO |