EXT_ORG_CD_TYPEEFFDTDefault Value: %DATE
A=Active
I=Inactive
Default Value: A
Default Value: EXORGCDTYPE_TBL.DESCR
E=EPS
N=None
Default Value: N
EXORGCDTYPE_TBL(SQL Table) |
Index Back |
|---|---|
External Org Code Type TableThis record is a setup table which contains different external coding schemes which are usable for organizations. EXT_ORG_CODE_VALUE is a special field which indicates a 'type' for the code being defined. Various other processes utilize this 'type' in order to perform specific operations. This allows for various coding schemes to be utilized within this setup table and for specific processes to identify and utilize sub-sets of the codes. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EXT_ORG_CD_TYPE |
Character(10) | VARCHAR2(10) NOT NULL | Ext Org Code Type |
| 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 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL |
Short Description
Default Value: EXORGCDTYPE_TBL.DESCR |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | EXT_ORG_CODE_VALUE | Character(1) | VARCHAR2(1) NOT NULL |
Ext Org Codes Value
E=EPS N=None Default Value: N |