SETIDPrompt Table: SP_SETID_NONVW
REG_LEDGERPrompt Table: REG_LEDGER_DEFN
REG_BODY_ID1=September
2=December
4=Year End
REG_LEDGER_BODY(SQL Table) |
Index Back |
|---|---|
Reg Ledger Contact InfoRegulatory Body and Contact Infomration |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SP_SETID_NONVW |
| 2 | REG_LEDGER |
Character(20) | VARCHAR2(20) NOT NULL |
Regulatory Ledger ID
Prompt Table: REG_LEDGER_DEFN |
| 3 | REG_BODY_ID |
Character(20) | VARCHAR2(20) NOT NULL | Reg Ledger - Regulatory Body ID |
| 4 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 5 | REG_ENTITY | Character(10) | VARCHAR2(10) NOT NULL | Regulatory Entity ID |
| 6 | REG_CITY_AND_ORG | Character(72) | VARCHAR2(72) NOT NULL | Reg Ledger City and Facility Name (72 char length as per MIS Guidelines) |
| 7 | REG_LED_SUBM_SEQ | Character(2) | VARCHAR2(2) NOT NULL | Reg Ledger Submission Sequence Number |
| 8 | REG_LED_SUBM_CODE | Character(1) | VARCHAR2(1) NOT NULL |
Reg Ledger Submission Type Code
1=September 2=December 4=Year End |
| 9 | REG_LED_SUBM_TEXT | Character(254) | VARCHAR2(254) NOT NULL | Reg Ledger Submission Narrative Text |