SSF_GRP_PST_AET

(SQL Table)
 Index Back

Group Line Population Select

State record for the Group Line Population Selection process.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

Default Value: OPR_DEF_TBL_CS.OPRID

3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
4 SCCPS_POP_SEL Character(1) VARCHAR2(1) NOT NULL Population Selection checkbox - used to incidate on run controls that pop selection was selected for use.

Y/N Table Edit

Default Value: Y

5 SCCPS_TOOL_ID Number(15,0) DECIMAL(15) NOT NULL Tool ID - the unique key for a pop select tool

Prompt Table: SCCPS_TOOL_VW

6 SCCPS_QUERY_NAME Character(50) VARCHAR2(50) NOT NULL Query / Section name used by population selection

Prompt Table: %EDITTABLE

7 SCCPS_CNTXT_ID Number(15,0) DECIMAL(15) NOT NULL Context ID - the unique key that identifies the pop selection context

Prompt Table: SCCPS_CNTXT_VW

8 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename
9 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File
10 SCCPS_FILE_PATH Character(254) VARCHAR2(254) NOT NULL Pop Select File Path and Name
11 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_CS.BUSINESS_UNIT

Prompt Table: GROUP_CONT_VW

12 SSF_GRPPST_TYPE Character(1) VARCHAR2(1) NOT NULL Group Post Pop Select Transaction Types.
1=Person Charges
2=Corp Charges
3=Corp Payments
4=Person Payments
5=Person Charge Reversal

Default Value: 1

13 GROUP_TYPE Character(1) VARCHAR2(1) NOT NULL Group Type

Prompt Table: GROUP_TYPE_TBL

14 BAL_STATUS Character(1) VARCHAR2(1) NOT NULL Deposit Balance
N=Not Balanced
Y=Balanced

Default Value: N

15 CONTROL_AMT Signed Number(16,2) DECIMAL(14,2) NOT NULL Control Total
16 CONTROL_CNT Number(10,0) DECIMAL(10) NOT NULL Control Count
17 ORIGIN_ID Character(5) VARCHAR2(5) NOT NULL Origin ID

Prompt Table: SP_ORIGIN_NONVW

18 CONTROL_CURRENCY Character(3) VARCHAR2(3) NOT NULL Control Currency

Default Value: BUS_UNIT_TBL_SF.BASE_CURRENCY

Prompt Table: CURRENCY_CD_TBL

19 BALANCE_GRP Character(1) VARCHAR2(1) NOT NULL Balance the Group

Y/N Table Edit

Default Value: N

20 GROUP_SOURCE Character(1) VARCHAR2(1) NOT NULL Group Source
E=External
O=On-Line

Default Value: O

21 TYPE_OF_GROUP Character(1) VARCHAR2(1) NOT NULL Type of Group
E=Student Group
X=External Org Group
22 ACCOUNT_TYPE_SF Character(3) VARCHAR2(3) NOT NULL Account Type

Prompt Table: ACCT_TYP_TBL_SF

23 ITEM_TYPE Character(12) VARCHAR2(12) NOT NULL Item Type

Prompt Table: %EDITTABLE

24 ITEM_EFFECTIVE_DT Date(10) DATE Item Effective Date

Default Value: %DATE

25 DESCR Character(30) VARCHAR2(30) NOT NULL Description
26 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PEOPLE_SRCH

27 DUE_DT Date(10) DATE Due Date
28 REF1_DESCR Character(30) VARCHAR2(30) NOT NULL Reference Nbr
29 STRM Character(4) VARCHAR2(4) NOT NULL Term

Prompt Table: SF_TERM_VW

30 CHARGE_PRIORITY Character(8) VARCHAR2(8) NOT NULL Charge Priority List

Prompt Table: PMT_CHRG_TBL

31 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID

Prompt Table: EXT_ORG_TBL

32 REFUND_EMPLID Character(11) VARCHAR2(11) NOT NULL Refund ID
33 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract Number

Prompt Table: TP_CONTRACT_VW

34 ITEM_TYPE_CD Character(1) VARCHAR2(1) NOT NULL Item Type Code
A=Application Fee
B=Billing Only
C=Charge
D=Deposit
F=Financial Aid
G=GL Interface Only
H=Withholding
I=Interest
L=Pre-Paid Tuition
P=Payment
R=Refund
T=Transfers
V=Contributor Relations
W=Waiver
X=Write-off
Z=Pay Plan Credit
35 RESTRICT_ACCT_FLG Character(1) VARCHAR2(1) NOT NULL Pay Entered Acct Only

Y/N Table Edit

Default Value: N

36 EXC_ACCT_TYPE_SF Character(3) VARCHAR2(3) NOT NULL Excess Account Type SF

Prompt Table: ACCT_TYP_SF_VW

37 EXC_ACCT_TYPE_FLG Character(1) VARCHAR2(1) NOT NULL Excess Account Type Flag

Y/N Table Edit

Default Value: N

38 CONTRACT_EMPLID Character(11) VARCHAR2(11) NOT NULL Contract ID

Prompt Table: PEOPLE_SRCH_SF

39 WRITEOFF_BY Character(2) VARCHAR2(2) NOT NULL Writeoff By
01=Entire Balance
02=Account Number
03=By Item Type
04=Account Type
40 SRVC_IND_CD Character(3) VARCHAR2(3) NOT NULL Service Indicator Cd

Prompt Table: %EDITTABLE4

41 BILLING_DT Date(10) DATE Billing Date
42 BILLING_FLAG Character(1) VARCHAR2(1) NOT NULL Billing Flag

Y/N Table Edit

Default Value: N

43 CUR_RT_TYPE Character(5) VARCHAR2(5) NOT NULL Currency Rate Type
44 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
45 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor
46 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
47 ORIGNL_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Default Value: BUS_UNIT_TBL_SF.BASE_CURRENCY

Prompt Table: CURRENCY_CD_TBL

48 ORIGNL_ITEM_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Item Amount
49 CREATE_ITEM Character(1) VARCHAR2(1) NOT NULL Create Item

Y/N Table Edit

Default Value: Y

50 ORIG_EFF_DT Date(10) DATE Original Effective Date
51 BASE_CURRENCY Character(3) VARCHAR2(3) NOT NULL Base Currency
52 ITEM_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Item Amount
53 EFFDT Date(10) DATE Effective Date

Default Value: %date

54 LASTUPDDTTM 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.
55 GROUP_LINE_NBR Number(6,0) INTEGER NOT NULL Group Line Number
56 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
57 AE_APPLID Character(12) VARCHAR2(12) NOT NULL Program Name (see PSAEAPPLDEFN).
58 AE_SECTION Character(8) VARCHAR2(8) NOT NULL Section
59 LINE_REASON_CD Character(4) VARCHAR2(4) NOT NULL Line Reason Code
60 SSF_RECORD_CNT Number(12,0) DECIMAL(12) NOT NULL Record Count
61 DIFFERENCE_CNT Signed Number(11,0) DECIMAL(10) NOT NULL Difference Count