CONTRACT_NUMSEQNOPrompt Table: CA_EARLYOUT_TBL
A=Active
I=Inactive
Default Value: A
C=Complete
P=Pending
R=Ready
X=Cancelled
Y/N Table Edit
A=Amount
P=Percent
CA_EARLY_OPTION(SQL Table) |
Index Back |
|---|---|
Contract Early Ending OptionThis record is associated with the contract header record and contains information regarding the early termination of the contract. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CONTRACT_NUM |
Character(25) | VARCHAR2(25) NOT NULL | Contract |
| 2 | SEQNO |
Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 3 | EARLY_OUT_CD | Character(4) | VARCHAR2(4) NOT NULL |
Early Out Option Code
Prompt Table: CA_EARLYOUT_TBL |
| 4 | EARLY_OUT_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Early Out Status
A=Active I=Inactive Default Value: A |
| 5 | CHG_ID | Character(10) | VARCHAR2(10) NOT NULL | Change Package Identifier. This is sequenced from 1 to N for each contract. |
| 6 | CHG_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Change Status indicates if this change package is open for further edit: pending, ready for processing by the app. engine component of contract change management (ready) or complete, meaning that no further edit is possible and all changes have been aplied.
C=Complete P=Pending R=Ready X=Cancelled |
| 7 | START_DT | Date(10) | DATE | Start Date |
| 8 | END_DT | Date(10) | DATE | End Date |
| 9 | PENALTY_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Penalty Applicable
Y/N Table Edit |
| 10 | PENALTY_AMT | Number(16,2) | DECIMAL(15,2) NOT NULL | Penalty Amount |
| 11 | PENALTY_NOTIFY_DT | Number(3,0) | SMALLINT NOT NULL | Notification Days |
| 12 | PENALTY_PCNT | Number(3,0) | SMALLINT NOT NULL | Penalty Percent |
| 13 | PENALTY_TYP | Character(1) | VARCHAR2(1) NOT NULL |
Penalty type
A=Amount P=Percent |
| 14 | EARLY_OUT_REAS | Character(4) | VARCHAR2(4) NOT NULL | Early Out Reason Code |