SETIDREG_LEDGERREG_BODY_IDSEQUENCE_NBRREG_LED_CNTCT_ROLE1=Technical
2=Approval Authority
REG_LED_CNTCT_CODE2=Job Title
4=Name
6=Fax Number
8=Voice Number
REG_LEDGER_BOD3(SQL Table) |
Index Back |
|---|---|
Reg Ledger Contact InfoRegulatory Body and Contact Information Detail |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | REG_LEDGER |
Character(20) | VARCHAR2(20) NOT NULL | Regulatory Ledger ID |
| 3 | REG_BODY_ID |
Character(20) | VARCHAR2(20) NOT NULL | Reg Ledger - Regulatory Body ID |
| 4 | SEQUENCE_NBR |
Number(2,0) | SMALLINT NOT NULL | Sequence Number |
| 5 | REG_LED_CNTCT_ROLE |
Character(2) | VARCHAR2(2) NOT NULL |
Reg Ledger Contact Person Role
1=Technical 2=Approval Authority |
| 6 | REG_LED_CNTCT_CODE |
Character(3) | VARCHAR2(3) NOT NULL |
Reg Ledger Contact Value Code
2=Job Title 4=Name 6=Fax Number 8=Voice Number |
| 7 | REG_LED_CNTCT_VAL | Character(36) | VARCHAR2(36) NOT NULL | Reg Ledger Contact Value |