CA_NOTE_DETAI_H

(SQL Table)

# 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 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

5 NOTES_SEQ_NUM Number(3,0) SMALLINT NOT NULL Notes Sequence Num
Default Value: 1

6 CONTRACT_LINE_NUM Number(3,0) SMALLINT NOT NULL Contract Line Num

7 BILL_PLAN_ID Character(10) VARCHAR2(10) NOT NULL Billing Plan ID

8 ACCT_PLAN_ID Character(10) VARCHAR2(10) NOT NULL Revenue Recognition Plan

9 MILESTONE_ID Character(6) VARCHAR2(6) NOT NULL Milestone_ID identifies the milestones that can be referenced from multiple functional areas.

10 INCENTIVE_ID Character(10) VARCHAR2(10) NOT NULL Investment Incentive ID

11 EARLY_OUT_CD Character(4) VARCHAR2(4) NOT NULL Early Out Option Code

12 NOTE_CLASS Character(2) VARCHAR2(2) NOT NULL Classification
C=Custom
S=Standard
Default Value: S

13 NOTE_TYPE Character(10) VARCHAR2(10) NOT NULL Note Type
Prompt Table: NOTE_TYPE

14 STD_NOTE_CD Character(10) VARCHAR2(10) NOT NULL Standard Note Code
Prompt Table: STD_NOTE

15 TEXT254 Character(254) VARCHAR2(254) NOT NULL Text

16 ADD_DTTM DateTime(26) TIMESTAMP Date Time Added

17 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.

18 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID

#	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	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
5	NOTES_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Notes Sequence Num Default Value: 1
6	CONTRACT_LINE_NUM	Number(3,0)	SMALLINT NOT NULL	Contract Line Num
7	BILL_PLAN_ID	Character(10)	VARCHAR2(10) NOT NULL	Billing Plan ID
8	ACCT_PLAN_ID	Character(10)	VARCHAR2(10) NOT NULL	Revenue Recognition Plan
9	MILESTONE_ID	Character(6)	VARCHAR2(6) NOT NULL	Milestone_ID identifies the milestones that can be referenced from multiple functional areas.
10	INCENTIVE_ID	Character(10)	VARCHAR2(10) NOT NULL	Investment Incentive ID
11	EARLY_OUT_CD	Character(4)	VARCHAR2(4) NOT NULL	Early Out Option Code
12	NOTE_CLASS	Character(2)	VARCHAR2(2) NOT NULL	Classification C=Custom S=Standard Default Value: S
13	NOTE_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Note Type Prompt Table: NOTE_TYPE
14	STD_NOTE_CD	Character(10)	VARCHAR2(10) NOT NULL	Standard Note Code Prompt Table: STD_NOTE
15	TEXT254	Character(254)	VARCHAR2(254) NOT NULL	Text
16	ADD_DTTM	DateTime(26)	TIMESTAMP	Date Time Added
17	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.
18	LAST_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Last Maintained By Operator ID