EX_PRIV_TMPL(SQL Table) |
Index Back |
---|---|
Privilege TemplatePrivilege Template. This record stores the privilege templates for the T&E approval transactions. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SP_SETID_NONVW |
2 | PRIVILEGE_TMPL_ID | Character(15) | VARCHAR2(15) NOT NULL | Privilege Template Id. Contains the name of the privilege template. |
3 | APPR_TRANS_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Approval Transaction Type.
CA=Cash Advance ER=Expense Report TA=Travel Authorization TJ=Time Adjustment TR=Time Report |
4 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
5 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
7 | DFLT_ACCTG_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Default Accounting Flag.
H=Hide M=Modify V=View Default Value: V |
8 | TRANS_LINES_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Transaction Lines Flag.
A=Add D=Delete F=Full M=Modify V=View Default Value: V |
9 | RCPT_REQUIRED_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Receipt Required Flag
H=Hide V=View Default Value: V |
10 | RCPT_VERIFIED_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Receipt Verified Flag.
H=Hide M=Modify V=View Default Value: V |
11 | USER_DEFAULTS_FLG | Character(1) | VARCHAR2(1) NOT NULL |
User Defaults Flag.
H=Hide V=View Default Value: V |
12 | ACCTG_DATE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Accounting Date Flag.
H=Hide M=Modify V=View Default Value: V |
13 | ADV_APPLIED_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Cash Advance Applied Flag.
H=Hide M=Modify V=View Default Value: V |
14 | ADV_TAX_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Cash Advance Tax Flag.
H=Hide M=Modify V=View Default Value: V |
15 | ADV_ADJUSTMENT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Cash Advance Adjustment Flag.
H=Hide M=Modify V=View Default Value: V |
16 | DISTRIBUTIONS_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Distributions flag.
F=Full H=Hide M=Modify V=View Default Value: V |
17 | CHARTFIELDS_GL_FLG | Character(1) | VARCHAR2(1) NOT NULL |
GL Chartfields flag.
H=Hide M=Modify V=View Default Value: V |
18 | CHARTFIELDS_PC_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Projects Chartfields Flag
H=Hide M=Modify V=View Default Value: V |
19 | VAT_INFO_FLG | Character(1) | VARCHAR2(1) NOT NULL |
VAT Information Flag
H=Hide M=Modify V=View Default Value: V |
20 | DOC_SEQ_TYPE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Document Sequence Flag
H=Hide M=Modify V=View Default Value: V |
21 | BILLING_ACT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Billing Action Flag
H=Hide M=Modify V=View Default Value: V |
22 | ATTACHMENT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Expense attachment flag
A=Add D=Delete F=Full V=View Default Value: V |
23 | ATTENDEES_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Expenses attendees flag
M=Modify V=View Default Value: V |