CA_NOTE_VW(SQL View) |
Index Back |
|---|
| SELECT CONTRACT_NUM ,NOTES_SEQ_NUM ,CONTRACT_COMPONENT ,CONTRACT_LINE_NUM ,BILL_PLAN_ID ,ACCT_PLAN_ID ,CHG_ID ,MS_SEQNUM ,INCENTIVE_ID ,EARLY_OUT_CD ,NOTE_CLASS ,NOTE_TYPE ,STD_NOTE_CD ,TEXT254 ,ADD_DTTM ,LAST_UPDATE_DTTM ,LAST_MAINT_OPRID FROM PS_CA_NOTE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CONTRACT_NUM | Character(25) | VARCHAR2(25) NOT NULL |
Contract
Prompt Table: CA_BU_SP_NONVW |
| 2 | NOTES_SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | Notes Sequence Num |
| 3 | CONTRACT_COMPONENT | Character(4) | VARCHAR2(4) NOT NULL |
Contract Component
AMT=Amount Allocation BIL=Billing Plan CHG=Amendments EO=Early Out Options HDR=Contract Header LINE=Contract Line MLST=Contract Milestone PEN=Bonus/Penalty PGP=Progress Payments Terms PPD=Prepaids PROJ=Contractor Terms REV=Revenue Plan TERM=Special Payment Terms |
| 4 | CONTRACT_LINE_NUM | Number(3,0) | SMALLINT NOT NULL |
Contract Line Num
Prompt Table: CA_DETAIL |
| 5 | BILL_PLAN_ID | Character(10) | VARCHAR2(10) NOT NULL |
Billing Plan ID
Prompt Table: CA_BILL_PLAN |
| 6 | ACCT_PLAN_ID | Character(10) | VARCHAR2(10) NOT NULL |
Revenue Recognition Plan
Prompt Table: CA_ACCTPLAN |
| 7 | CHG_ID | Character(10) | VARCHAR2(10) NOT NULL |
Change Package Identifier. This is sequenced from 1 to N for each contract.
Prompt Table: CA_CHG_HDR |
| 8 | MS_SEQNUM | Number(3,0) | SMALLINT NOT NULL | Milestone Number |
| 9 | INCENTIVE_ID | Character(10) | VARCHAR2(10) NOT NULL | Investment Incentive ID |
| 10 | EARLY_OUT_CD | Character(4) | VARCHAR2(4) NOT NULL |
Early Out Option Code
Prompt Table: CA_EARLYOUT_TBL |
| 11 | NOTE_CLASS | Character(2) | VARCHAR2(2) NOT NULL |
Classification
C=Custom S=Standard |
| 12 | NOTE_TYPE | Character(10) | VARCHAR2(10) NOT NULL |
Note Type
Prompt Table: NOTE_TYPE |
| 13 | STD_NOTE_CD | Character(10) | VARCHAR2(10) NOT NULL |
Standard Note Code
Prompt Table: STD_NOTE |
| 14 | TEXT254 | Character(254) | VARCHAR2(254) NOT NULL | Text |
| 15 | ADD_DTTM | DateTime(26) | TIMESTAMP | Date Time Added |
| 16 | LAST_UPDATE_DTTM | 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. |
| 17 | LAST_MAINT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Last Maintained By Operator ID |