INSTITUTIONDefault Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table: INSTITUTN_SCRTY
TREE_NAMEPrompt Table: SSR_TREEDEFN_VW
TREE_EFFDTROW_NUMPrompt Table: SSR_TST_CAT_NLD
SSR_TST_TRV_NLD(SQL Table) |
Index Back |
|---|---|
Test Tree Table ValidationTest Tree Table Validation |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTN_SCRTY |
| 2 | TREE_NAME |
Character(18) | VARCHAR2(18) NOT NULL |
Tree Name
Prompt Table: SSR_TREEDEFN_VW |
| 3 | TREE_EFFDT |
Date(10) | DATE | Effective date of the Tree |
| 4 | ROW_NUM |
Number(3,0) | SMALLINT NOT NULL | Row Number |
| 5 | MESSAGE_SET_NBR | Number(5,0) | INTEGER NOT NULL | Message Set Number. This field refers to the Message Set Number in the Message Catalog. |
| 6 | MESSAGE_NBR | Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |
| 7 | SSR_TST_ID_NLD | Character(8) | VARCHAR2(8) NOT NULL |
Test ID
Prompt Table: SSR_TST_CAT_NLD |
| 8 | TREE_LEVEL_NUM | Number(3,0) | SMALLINT NOT NULL | Parent tree level if this is a part of the PSTREEBRANCH record |