REG_TRXPrompt Table: REG_TRX_TBL
REG_REGIONPrompt Table: REG_REGION_TBL
Y/N Table Edit
Default Value: N
REG_TRX_REGION(SQL Table) |
Index Back |
|---|---|
Reg Regions for TransactionsGives all the appropriate regulatory regions for the various application/transactions. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | REG_TRX |
Character(10) | VARCHAR2(10) NOT NULL |
REgulatory transaction
Prompt Table: REG_TRX_TBL |
| 2 | REG_REGION |
Character(5) | VARCHAR2(5) NOT NULL |
Regulatory Region
Prompt Table: REG_REGION_TBL |
| 3 | SYSTEM_DATA_FLG | Character(1) | VARCHAR2(1) NOT NULL |
This Y/ N field is used to identify which rows in a table are considered SYSTEM DATA.
Y/N Table Edit Default Value: N |