| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_CS.BUSINESS_UNIT
Prompt Table:
SP_BU_SF_NONVW
|
| 2 |
GROUP_ID_SF |
Character(15) |
VARCHAR2(15) NOT NULL |
Group ID
|
| 3 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Default Value: OPR_DEF_TBL_CS.OPRID
Prompt Table:
OPRID_VW
|
| 4 |
ASSN_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Assigned Operator ID
Prompt Table:
OPRID_VW
|
| 5 |
GROUP_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Group Type
Prompt Table:
GROUP_TYPE_TBL
|
| 6 |
BAL_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Deposit Balance
N=Not Balanced
Y=Balanced
Default Value: N
|
| 7 |
EDIT_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Editing
E=Edited
N=Not Edited
Default Value: N
|
| 8 |
POST_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Posting Status
B=Balance
C=Complete
E=Errors
I=Incomplete
N=Not Posted
R=Reversed
Default Value: N
|
| 9 |
POST_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Posting Action
A=Available for Posting
D=Do Not Post
N=Posted
W=Waiting for Approval
Default Value: A
|
| 10 |
CONTROL_AMT |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Control Total
|
| 11 |
CONTROL_CNT |
Number(10,0) |
DECIMAL(10) NOT NULL |
Control Count
|
| 12 |
DIFFERENCE_AMT |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Difference Amount
|
| 13 |
DIFFERENCE_CNT |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Difference Count
|
| 14 |
ENTERED_AMT |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Entered Total
|
| 15 |
ENTERED_CNT |
Number(10,0) |
DECIMAL(10) NOT NULL |
Entered Count
|
| 16 |
POSTED_COUNT |
Number(10,0) |
DECIMAL(10) NOT NULL |
Payments Set To Post
|
| 17 |
POSTED_TOTAL |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Posted Total
|
| 18 |
ORIGIN_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Origin ID
Prompt Table:
SP_ORIGIN_NONVW
|
| 19 |
RECEIVED_DT |
Date(10) |
DATE NOT NULL |
Certificate Received Date
Default Value: %date
|
| 20 |
ENTRY_DT |
Date(10) |
DATE NOT NULL |
This field pertains to the date a person enters a country on a specific visa.
Default Value: %date
|
| 21 |
POST_DT |
Date(10) |
DATE |
The Date a transaction was Posted.
Default Value: %date
|
| 22 |
ACCOUNTING_DT |
Date(10) |
DATE NOT NULL |
Accounting Date
Default Value: %date
|
| 23 |
GROUP_ID_ORIG |
Character(15) |
VARCHAR2(15) NOT NULL |
Original Group ID
Prompt Table:
GROUP_CONT_INFO
|
| 24 |
CONTROL_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
Control Currency
Prompt Table:
CURRENCY_CD_TBL
|
| 25 |
BALANCE_GRP |
Character(1) |
VARCHAR2(1) NOT NULL |
Balance the Group
Y/N Table Edit
Default Value: N
|
| 26 |
MESSAGE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
|
| 27 |
GROUP_SOURCE |
Character(1) |
VARCHAR2(1) NOT NULL |
Group Source
E=External
O=On-Line
Default Value: O
|
| 28 |
TYPE_OF_GROUP |
Character(1) |
VARCHAR2(1) NOT NULL |
Type of Group
E=Student Group
X=External Org Group
|
| 29 |
APPROVAL_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Operator ID Approval
|
| 30 |
APPROVAL_DATETIME |
DateTime(26) |
TIMESTAMP |
Datetime Approval
|
| 31 |
APPR_OPRID_LAST |
Character(30) |
VARCHAR2(30) NOT NULL |
Operator ID Last Approval
|
| 32 |
APPR_DATETIME_LAST |
DateTime(26) |
TIMESTAMP |
Last Datetime Approval
|
| 33 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 34 |
FROM_DATE |
Date(10) |
DATE |
From Date
|
| 35 |
TO_DATE |
Date(10) |
DATE |
Latest Date to be sent to PYR
|
| 36 |
BEGIN_GRP_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Begin Group ID
|
| 37 |
END_GRP_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Group ID
|