| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PSARCH_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Archive ID (see PSARCHTEMPLATE).
|
| 2 |
PSARCH_BATCHNUM |
Number(30,0) |
DECIMAL(30) NOT NULL |
Archive Batch Number
|
| 3 |
CONTRACT_NUM |
Character(25) |
VARCHAR2(25) NOT NULL |
Contract
Prompt Table:
CA_BU_SP_NONVW
|
| 4 |
NOTES_SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Notes Sequence Num
Default Value: 1
|
| 5 |
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
Default Value: HDR
|
| 6 |
CONTRACT_LINE_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Contract Line Num
Prompt Table:
CA_DETAIL
|
| 7 |
BILL_PLAN_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Billing Plan ID
Prompt Table:
CA_BILL_PLAN
|
| 8 |
ACCT_PLAN_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Revenue Recognition Plan
Prompt Table:
CA_ACCTPLAN
|
| 9 |
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
|
| 10 |
MS_SEQNUM |
Number(3,0) |
SMALLINT NOT NULL |
Milestone Number
Prompt Table:
CA_MILESTONE
|
| 11 |
INCENTIVE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Investment Incentive ID
Prompt Table:
CA_BONUS_PENLTY
|
| 12 |
CA_PGP_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
Progress Payment Sequence
Prompt Table:
CA_PGP_TERMS
|
| 13 |
EARLY_OUT_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Early Out Option Code
Prompt Table:
CA_EARLY_OPTION
|
| 14 |
NOTE_CLASS |
Character(2) |
VARCHAR2(2) NOT NULL |
Classification
C=Custom
S=Standard
Default Value: S
|
| 15 |
NOTE_TYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
Note Type
Prompt Table:
NOTE_TYPE
|
| 16 |
STD_NOTE_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Standard Note Code
Prompt Table:
STD_NOTE
|
| 17 |
TEXT254 |
Character(254) |
VARCHAR2(254) NOT NULL |
Text
|
| 18 |
ADD_DTTM |
DateTime(26) |
TIMESTAMP |
Date Time Added
|
| 19 |
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.
|
| 20 |
LAST_MAINT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Maintained By Operator ID
|