CC_RPT_AET

(SQL Table)
Index Back

ProCard Report AET

AE_SECTION = Crystal Report Name, ex POY8010

# 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).
3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
4 AE_APPLID Character(12) VARCHAR2(12) NOT NULL Program Name (see PSAEAPPLDEFN).
5 AE_SECTION Character(8) VARCHAR2(8) NOT NULL Section
6 PROCESS_INST_STG Number(10,0) DECIMAL(10) NOT NULL Stage Record Process Instance
7 COUNTER Number(10,0) DECIMAL(10) NOT NULL Counter
8 ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).
9 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

10 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
11 CREDIT_CARD_VENDOR Character(5) VARCHAR2(5) NOT NULL Corporate Card Vendor
12 CRDMEM_ACCT_NBR Character(44) VARCHAR2(44) NOT NULL Cardmember Number
13 CC_MASK_OPT Character(1) VARCHAR2(1) NOT NULL Display Unmasked Card Number
14 DISPLAY_DIGITS Number(3,0) SMALLINT NOT NULL Number of Digits to Display
15 OPRDEFNDESC Character(30) VARCHAR2(30) NOT NULL Description field for a user
16 FROM_DATE Date(10) DATE From Date
17 THRU_DATE Date(10) DATE Through Date
18 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
19 URL Character(254) VARCHAR2(254) NOT NULL Internet URL (Universal Resource Locator)