FIELDNAMEEFF=Effective Dated Table
NEFF=No Effective Date Table
SEFF=SetId & Effdt Table
SET=SetId without Effdt Table
XLAT=TranslateTable
BI_FLD_DESCR(SQL Table) |
Index Back |
|---|---|
Field Description System Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 2 | DETAIL_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Detail Flag |
| 3 | SETID_FIELD | Character(18) | VARCHAR2(18) NOT NULL | SetID Field |
| 4 | FIELD_DESCR_NAME | Character(18) | VARCHAR2(18) NOT NULL | Decription Field name |
| 5 | FIELDDESCR | Character(20) | VARCHAR2(20) NOT NULL | Description |
| 6 | BASE_RECORD | Character(15) | VARCHAR2(15) NOT NULL | Base Record |
| 7 | RELLANGRECNAME | Character(15) | VARCHAR2(15) NOT NULL | Related Language Record Name |
| 8 | DESCR_TBL_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Description table type
EFF=Effective Dated Table NEFF=No Effective Date Table SEFF=SetId & Effdt Table SET=SetId without Effdt Table XLAT=TranslateTable |
| 9 | SETCNTRLFLD | Character(18) | VARCHAR2(18) NOT NULL | Tree Structure Node User Key Field Name |
| 10 | KEYNAME | Character(18) | VARCHAR2(18) NOT NULL | Key Name |