ELEMENT_LABELEFFDTDefault Value: %date
A=Active
I=Inactive
Default Value: A
Prompt Table: XBRL_SETUP_NS
Prompt Table: XBRL_CONTEXT
0=Debit Balance
1=Credit Balance
XBRL_ELMT_TBL(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ELEMENT_LABEL |
Character(30) | VARCHAR2(30) NOT NULL | Element name to identify (in peoplesoft) an element along with its label. |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 4 | XBRL_ELEMENT_ID | Character(254) | VARCHAR2(254) NOT NULL | XBRL element, defined in a schema file in the taxonomy. |
| 5 | XBRL_ELEMENT_LBL | Character(254) | VARCHAR2(254) NOT NULL | Label associated with an XBRL element. The label is defined in a label linkbase file in the taxonomy. |
| 6 | NAMESPACE_ALIAS | Character(10) | VARCHAR2(10) NOT NULL |
NameSpace Alias
Prompt Table: XBRL_SETUP_NS |
| 7 | CONTEXT | Character(5) | VARCHAR2(5) NOT NULL |
Context Name
Prompt Table: XBRL_CONTEXT |
| 8 | DRCR | Character(1) | VARCHAR2(1) NOT NULL |
XBRL Balance
0=Debit Balance 1=Credit Balance |