ct_ca_line_limits_summ_by_type

Purpose of Query

Contract Line Limits Summary by Type- This query can be used any agency that uses the Customer Contract module.

Folder

CO

Tables

A CTW_CALMT_FEDTL - Cntrct Line Lmt and Fee Detail

Join B CTW_CA_CNTR_HDR - Customer Contract Header

Note: A JOIN is an SQL command that is used to relate two or more data tables (Records in PeopleSoft) based on the use of related (key) fields from one table to the next. Once joined, data can be retrieved without repeating all of the data in every table.

Prompts

BUSINESS_UNIT - Business Unit - (Equal To)

CONTRACT_TYPE - Contract Type – (Equal To)

Criteria

No criteria beyond the runtime prompts.

Note: Runtime prompts are included as criteria.

Fields

Col / Record.Fieldname / Format / Ord / XLAT / Agg / Heading Text
1 / B.BUSINESS_UNIT - Business Unit / Char5 / 1 / Contract BU
2 / B.CONTRACT_TYPE - Contract Type / Char15 / 2 / Contract Type
3 / B.SOLD_TO_CUST_ID - Sold To Customer / Char15 / 3 / Customer ID
4 / A.CONTRACT_NUM - Contract Number / Char25 / 4 / Contract Number
5 / A.CONTRACT_LINE_NUM - Contract Line Num / Num3.0 / 5 / Contract Line
6 / A.CT_AWARDD_BSE_AMT - Awarded Base Amount / SNm25.3 / Awarded Amount - Line
7 / A.CT_LIMIT_AMT_BIL - Billing (Funded) / SNm25.3 / Billing Limit Amount - Line
8 / A.CT_LMT_PROC_AMT_B - Funded Processed Amount / SNm25.3 / Processed Amount - Line
9 / A.CT_LIMIT_AMT_BIL - A.CT_LMT_PROC_AMT_B / SNm28.3 / Remaining Amount - Line
10 / A.CT_LMT_EXCES_AMT_B - Funded Excess Amount / SNm25.3 / Over the Limit Amount - Line
11 / A.CT_LMT_LST_PRCDT_B - Last Funded Process Date / Date / Last Process Date
12 / A.CT_LMT_LST_TXNDT_B - Last Funded Transaction Date / Date / Last Transaction Date
13 / A.CT_LMT_RCHD_DT_BIL - Date Funded Limit Reached / Date / Date Limit Reached
14 / A.CHG_ID - Amendment Number / Char10 / Amendment Number
15 / A.CHG_STATUS - Amendment Status / Char1 / N / Amendment Status

Note: Field Column 9 is an Expression. Expressions are calculations that PeopleSoft Query performs as part of a query. Use them when you must calculate a value that PeopleSoft Query does not provide by default—for example, to add the values from two fields together or to multiply a field value by a constant.

You can work with an expression as if it were a field in the query: select it for output, change its column heading, or choose it as an “order by” column.

In Query Manager, you can use expressions in two ways:

As comparison values in selection criteria.

As columns in the query output.

In this case, the Expression (A.CT_LIMIT_AMT_BIL - A.CT_LMT_PROC_AMT_B). instructs the query, when run, to subtract the contract processed amount from the billing amount limit to arrive at a remaining amount.

Do Not copy, modify, or delete