ACTIONPrompt Table: ACTION_TBL
SETIDPrompt Table: SETID_TBL
CONTRACT_TYPEPrompt Table: WF_CNT_FRA_VW
WF_CNT_NAT_FRA(SQL Table) |
Index Back |
|---|---|
Stores the mappingStores the mapping b/w the action/contract type and contract nature for regulatory requirement of france |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ACTION |
Character(3) | VARCHAR2(3) NOT NULL |
Action
Prompt Table: ACTION_TBL |
| 2 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SETID_TBL |
| 3 | CONTRACT_TYPE |
Character(3) | VARCHAR2(3) NOT NULL |
Contract Type
Prompt Table: WF_CNT_FRA_VW |
| 4 | CNT_NATURE_FRA | Character(2) | VARCHAR2(2) NOT NULL | Contract Nature for Regulatory Report FRA |