INSTITUTIONDefault Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table: INSTITUTN_SCRTY
TREE_NAMEPrompt Table: SSR_TREEDEFN_VW
TREE_EFFDTY/N Table Edit
Default Value: N
I=Invalid Tree
N=Not Validated
V=Validated
Default Value: N
SSR_TSTTREE_NLD(SQL Table) |
Index Back |
|---|---|
Test Tree TableTest Tree Table |
| # | 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 | SSR_TREE_VALID_NLD | Character(1) | VARCHAR2(1) NOT NULL |
Validation Tree Report
Y/N Table Edit Default Value: N |
| 5 | SSR_RESTREEVAL_NLD | Character(1) | VARCHAR2(1) NOT NULL |
Tree Validation Result
I=Invalid Tree N=Not Validated V=Validated Default Value: N |
| 6 | VALIDATED_DT | Date(10) | DATE | The date the inbound deduction data from the Supplier was validated. |