SCC_USI_ORG_CODEPrompt Table: SCC_NIDTYPE1_VW
Prompt Table: NAME_USAGE_TBL
Prompt Table: ADDR_USAGE_TBL
Prompt Table: ADDR_USAGE_TBL
Prompt Table: PHONE_USAGE_TBL
Prompt Table: SCC_USI_MAP_VW
Prompt Table: SCC_USI_MAP_VW
SCC_USI_SETUP(SQL Table) |
Index Back |
|---|---|
USI Setup |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SCC_USI_ORG_CODE |
Character(6) | VARCHAR2(6) NOT NULL | USI Organisation Code |
| 2 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 3 | SCC_USI_NID_TYPE | Character(6) | VARCHAR2(6) NOT NULL |
National ID Type
Prompt Table: SCC_NIDTYPE1_VW |
| 4 | SCC_USI_NAME_USAGE | Character(10) | VARCHAR2(10) NOT NULL |
Name Usage
Prompt Table: NAME_USAGE_TBL |
| 5 | SCC_USI_ADDR_USAGE | Character(10) | VARCHAR2(10) NOT NULL |
Address Usage
Prompt Table: ADDR_USAGE_TBL |
| 6 | SCC_USI_EMAL_USAGE | Character(10) | VARCHAR2(10) NOT NULL |
Email Address Usage
Prompt Table: ADDR_USAGE_TBL |
| 7 | SCC_USI_PHN_USAGE | Character(10) | VARCHAR2(10) NOT NULL |
Mobile Phone Usage (SMS)
Prompt Table: PHONE_USAGE_TBL |
| 8 | SCC_USI_REQST_ID | Number(8,0) | INTEGER NOT NULL | USI Request ID |
| 9 | SCC_USI_CNTRY | Character(100) | VARCHAR2(100) NOT NULL |
USI Country
Prompt Table: SCC_USI_MAP_VW |
| 10 | SCC_USI_CNTRY_DEF | Character(100) | VARCHAR2(100) NOT NULL |
USI Country
Prompt Table: SCC_USI_MAP_VW |