MERCHANTIDRS_USERIDSEQNUMRS_PROJHIST_EXT(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | MERCHANTID |
Character(30) | VARCHAR2(30) NOT NULL | Merchant ID |
| 2 | RS_USERID |
Character(15) | VARCHAR2(15) NOT NULL | Resource ID |
| 3 | SEQNUM |
Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 4 | RS_ROLE_STR | Character(30) | VARCHAR2(30) NOT NULL | Role |
| 5 | RS_COMPETENCY_EXT | Character(20) | VARCHAR2(20) NOT NULL | Competency |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | RS_CLIENT_NAME | Character(30) | VARCHAR2(30) NOT NULL | Client Name |
| 8 | CONTACT_NAME | Character(50) | VARCHAR2(50) NOT NULL | The individual contact name associated with a given bank/counterparty. |
| 9 | RS_RATE | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | External Resource Rate |
| 10 | RS_PROJ_DESC | Long Character(4000) | CLOB | Assignment Description |