CONTRACT_NUMCONTRACT_PPD_SEQDTTM_STAMPA=Prepaid made Ready
D=Use Sequence Moved Down
H=Prepaid placed on hold
O=Prepaid removed from hold
U=Use Sequence Moved Up
X=Prepaid Cancelled
A=Ready
C=Completed
I=Inactive
P=Pending
X=Cancelled
CA_PPD_AUD_VW(SQL View) |
Index Back |
|---|---|
Contract Prepaid Audit History |
| SELECT CONTRACT_NUM , CONTRACT_PPD_SEQ , DTTM_STAMP , OPRID , CA_PPD_ACTION , CA_PPD_STATUS , REMAINING_AMOUNT FROM PS_CA_PREPAID_AUD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CONTRACT_NUM |
Character(25) | VARCHAR2(25) NOT NULL | Contract |
| 2 | CONTRACT_PPD_SEQ |
Number(5,0) | INTEGER NOT NULL | Prepaid Add Sequence |
| 3 | DTTM_STAMP |
DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 4 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 5 | CA_PPD_ACTION | Character(1) | VARCHAR2(1) NOT NULL |
Action Type
A=Prepaid made Ready D=Use Sequence Moved Down H=Prepaid placed on hold O=Prepaid removed from hold U=Use Sequence Moved Up X=Prepaid Cancelled |
| 6 | CA_PPD_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Prepaid Balance Status
A=Ready C=Completed I=Inactive P=Pending X=Cancelled |
| 7 | REMAINING_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Remaining Amount |