| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table:
OPRID_VW
|
| 2 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 3 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_CA.BUSINESS_UNIT
Prompt Table:
SP_BU_CA_NONVW
|
| 4 |
SOLD_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Sold To Customer
Prompt Table:
CUST_SLD_VW
|
| 5 |
CONTRACT_TYPE |
Character(15) |
VARCHAR2(15) NOT NULL |
Contract Type
Prompt Table:
CA_TYPE_TBL
|
| 6 |
CONTRACT_NUM |
Character(25) |
VARCHAR2(25) NOT NULL |
Contract
Prompt Table:
CA_CNTR_SRCH_VW
|
| 7 |
CA_PROC_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
CA_STATUS is a user defined status field that maps (many to 1) to the contract Processing Status field. Process Status indicates what change processing is available.
A=Active
C=Closed
P=Pending
Default Value: A
|
| 8 |
RNW_PKG_STATUS |
Character(4) |
VARCHAR2(4) NOT NULL |
PSIRS-KK
CAN=Canceled
PND=Pending
PRG=In Progress
|
| 9 |
RNW_CYCLE_STATUS |
Character(4) |
VARCHAR2(4) NOT NULL |
PSIRS-KK
DON=Done
PND=Pending
RDY=Ready
|
| 10 |
RNW_LINKED |
Character(1) |
VARCHAR2(1) NOT NULL |
PSIRS-KK
|
| 11 |
DAY_INCREMENT |
Number(3,0) |
SMALLINT NOT NULL |
Day Increment
|
| 12 |
AP_STATUS |
Character(3) |
VARCHAR2(3) NOT NULL |
Rev Rec Plan Status
CAN=Cancelled
DON=Completed
NEW=Pending
PRG=In Progress
RDY=Ready
RIP=Reversal in Progress
RQD=Action Required
RVS=Reversed
Default Value: NEW
|
| 13 |
BP_STATUS |
Character(3) |
VARCHAR2(3) NOT NULL |
Billing Plan Status
CAN=Cancelled
DON=Completed
PND=Pending
PRG=In Progress
RCL=Recycled
RDY=Ready
RIP=Reversal In Progress
RQD=Action Required
RRP=Recycled
RVS=Reversed
Default Value: PND
|
| 14 |
MILESTONE_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
Milestone Status
C=Completed
P=Pending
R=Ready
X=Cancelled
|
| 15 |
CA_PPD_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Prepaid Balance Status
A=Ready
C=Completed
I=Inactive
P=Pending
X=Cancelled
|
| 16 |
HOLD_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Hold
N=Hold
Y=Hold
|
| 17 |
PREPAID_TRANS_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Prepaid Transaction Type
BUN=Inclusive Services
UNB=Non-Inclusive Services
UNP=Non-Inclusive Add'l Purchase
|
| 18 |
CONTRACT_ADMIN |
Character(40) |
VARCHAR2(40) NOT NULL |
Contract Administrator defined on CABU.
Prompt Table:
MEMBER_VW
|
| 19 |
LMT_RPT_BY_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Limit Report By Option
1=Remaining Amount
2=Excess Amount
3=All
Default Value: 1
|
| 20 |
RATE_DEF_BIL |
Character(1) |
VARCHAR2(1) NOT NULL |
Rate Definition to track billing rates.
|
| 21 |
RATE_DEF_REV |
Character(1) |
VARCHAR2(1) NOT NULL |
Rate Definition to track revenue rates.
|
| 22 |
CA_RPT_LMT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Funded / Revenue Limit Type Indicator for the Contracts Limit Report
1=Funding and Billing
2=Revenue
3=All
Default Value: 1
|
| 23 |
LMT_MAX_REMAIN_PCT |
Number(12,8) |
DECIMAL(11,8) NOT NULL |
Maximum Remaining Percent for Limits
|
| 24 |
CA_RQST_SRC |
Character(3) |
VARCHAR2(3) NOT NULL |
Contract Classification
FED=Federal Reimbursable Agreement
GEN=Generic Application
GOV=Government
INT=Internal
OND=CRM Field Services On Demand
STD=Standard
Default Value: STD
|