TD_TREE_HDR(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 2 | TD_TREE_ID |
Character(8) | VARCHAR2(8) NOT NULL | Tree ID |
| 3 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | TD_TREE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Tree Type
C=Customer P=Product |
| 5 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: I |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | TD_LAST_AUTO_GEN | Character(8) | VARCHAR2(8) NOT NULL |
Last AutoGen ID
Default Value: 0 |
| 8 | TD_ALLOW_DUPE_CUST | Character(1) | VARCHAR2(1) NOT NULL |
Allow Duplicate Customers
Y/N Table Edit Default Value: N |
| 9 | UPDATED_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
UPDATED FLAG
Default Value: N |
| 10 | OPRID_ENTERED_BY | Character(30) | VARCHAR2(30) NOT NULL | Entered By 07/25/2011 MRAD 12383033 :Ensured that OPRID_ENTERED_BY is set with format type of MixedCase. 03/22/2013 GL 16482301: Switched OPRID_ENTERED_BY back to MixedCase again. Please don't change it to UpperCase!!! FYI - The alternatives to use a User ID as uppercase: 1) Create your own User ID, add comments in the Field Properties, and fill out the Owner ID 2) Use %Upper meta-SQL in SQL statements 3) Use Upper function in peoplecodes |
| 11 | ENTERED_DT | Date(10) | DATE | Entered on |
| 12 | OPRID_MODIFIED_BY | Character(30) | VARCHAR2(30) NOT NULL | Last User to Modify Entered By 07/25/2011:Ensured that OPRID_MODIFIED_BY is set with format type of MixedCase. |
| 13 | LAST_UPDATE_DT | Date(10) | DATE |
Last Updated
Default Value: %Date |
| 14 | TD_UPDATE_TREE | Character(1) | VARCHAR2(1) NOT NULL |
Update Tree Statistics
B=Automatically Run Process M=Manually Run Process O=Online Update Default Value: O |
| 15 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL |
Run Control ID
Prompt Table: TD_GAPTREE_HDR |
| 16 | COMMENTS | Long Character | CLOB | Comment |